Probleme with MySQL queries

Hello

There is a problem when I select a line in mysql table and afet I
delete it.


1/ It works :=20
$sql =3D 'SELECT * FROM table WHERE id=3D"10" ';
$req =3D mysql_query($sql) or die('Erreur SQL
!
'.$sql.'
'.mysql_error());=20
while($data =3D mysql_fetch_assoc($req)) {
echo $data['id'];
}
$sql2 =3D 'DELETE FROM table WHERE id=3D"10" ';
$req2 =3D mysql_query($sql2) or die('Erreur SQL
!
'.$sql2.'
'.mysql_error());

2/ It don't work :=20

$sql =3D 'SELECT * FROM table WHERE id=3D"'.$var.'" ';
$req =3D mysql_query($sql) or die('Erreur SQL
!
'.$sql.'
'.mysql_error());=20
while($data =3D mysql_fetch_assoc($req)) {
echo $data['id'];
}
$sql2 =3D 'DELETE FROM table WHERE id=3D"'.$var.'" ';
$req2 =3D mysql_query($sql2) or die('Erreur SQL
!
'.$sql2.'
'.mysql_error());


Results of this queries :=20

In first case (it works) : I see the id get in mysql and it delete it
after

In second case (it don't work) : I don't see id get in mysql. It's like
if it delete it first and after select.

I have not error in php log.


If somebody can help me, because I try since few hours...


Best regards,

David DURIEUX
Tel : +33 (0)4.74.04.81.34
Port : +33 (0)6.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

> $sql = 'SELECT * FROM table WHERE id="'.$var.'" ';
> $req = mysql_query($sql) or die('Erreur SQL
> !
'.$sql.'
'.mysql_error());
> while($data = mysql_fetch_assoc($req)) {
> echo $data['id'];
> }
> $sql2 = 'DELETE FROM table WHERE id="'.$var.'" ';
> $req2 = mysql_query($sql2) or die('Erreur SQL
> !
'.$sql2.'
'.mysql_error());

I'll ask the obvious: where and how is $var set, and did you echo your
$sql variable to try the query on your mysql server directly?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Hi ,

For this situation , you should print out the SQL statement to check
the value of the variable "$var" .

--------------------------------------------------
From: "David DURIEUX"
Sent: Wednesday, September 03, 2008 5:07 PM
To:
Subject: [PHP-DB] Probleme with MySQL queries

> Hello
>
> There is a problem when I select a line in mysql table and afet I
> delete it.
>
>
> 1/ It works :
> $sql = 'SELECT * FROM table WHERE id="10" ';
> $req = mysql_query($sql) or die('Erreur SQL
> !
'.$sql.'
'.mysql_error());
> while($data = mysql_fetch_assoc($req)) {
> echo $data['id'];
> }
> $sql2 = 'DELETE FROM table WHERE id="10" ';
> $req2 = mysql_query($sql2) or die('Erreur SQL
> !
'.$sql2.'
'.mysql_error());
>
> 2/ It don't work :
>
> $sql = 'SELECT * FROM table WHERE id="'.$var.'" ';
> $req = mysql_query($sql) or die('Erreur SQL
> !
'.$sql.'
'.mysql_error());
> while($data = mysql_fetch_assoc($req)) {
> echo $data['id'];
> }
> $sql2 = 'DELETE FROM table WHERE id="'.$var.'" ';
> $req2 = mysql_query($sql2) or die('Erreur SQL
> !
'.$sql2.'
'.mysql_error());
>
>
> Results of this queries :
>
> In first case (it works) : I see the id get in mysql and it delete it
> after
>
> In second case (it don't work) : I don't see id get in mysql. It's like
> if it delete it first and after select.
>
> I have not error in php log.
>
>
> If somebody can help me, because I try since few hours...
>
>
> Best regards,
>
> David DURIEUX
> Tel : +33 (0)4.74.04.81.34
> Port : +33 (0)6.34.99.45.18
> Mail : d.durieux@siprossii.com
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
> --
> PHP Database Mailing List (http://www.php.net/)
> To unsubscribe, visit: http://www.php.net/unsub.php
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

At the begining $var is $_GET['id'] and after I try directly $var =3D 10
but no changes.

On the server directly, I can only try with the values :=20
$sql =3D 'SELECT * FROM table WHERE id=3D"10" '; and for this no problem.

The problem is when I use a variable in query


Best regards,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 11:13:11 +0200
"Evert Lammerts" a =E9crit:

>> $sql =3D 'SELECT * FROM table WHERE id=3D"'.$var.'" ';
>> $req =3D mysql_query($sql) or die('Erreur SQL
>> !
'.$sql.'
'.mysql_error());
>> while($data =3D mysql_fetch_assoc($req)) {
>> echo $data['id'];
>> }
>> $sql2 =3D 'DELETE FROM table WHERE id=3D"'.$var.'" ';
>> $req2 =3D mysql_query($sql2) or die('Erreur SQL
>> !
'.$sql2.'
'.mysql_error());
>
>I'll ask the obvious: where and how is $var set, and did you echo your
>$sql variable to try the query on your mysql server directly?
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

I have print and it's OK, the query is good like if I put the value
directly in the query

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 17:17:51 +0800
"Kendo Tom" a =E9crit:

>Hi ,
>
> For this situation , you should print out the SQL statement to
> check=20
>the value of the variable "$var" .
>
>--------------------------------------------------
>From: "David DURIEUX"
>Sent: Wednesday, September 03, 2008 5:07 PM
>To:
>Subject: [PHP-DB] Probleme with MySQL queries
>
>> Hello
>>
>> There is a problem when I select a line in mysql table and afet I
>> delete it.
>>
>>
>> 1/ It works :
>> $sql =3D 'SELECT * FROM table WHERE id=3D"10" ';
>> $req =3D mysql_query($sql) or die('Erreur SQL
>> !
'.$sql.'
'.mysql_error());
>> while($data =3D mysql_fetch_assoc($req)) {
>> echo $data['id'];
>> }
>> $sql2 =3D 'DELETE FROM table WHERE id=3D"10" ';
>> $req2 =3D mysql_query($sql2) or die('Erreur SQL
>> !
'.$sql2.'
'.mysql_error());
>>
>> 2/ It don't work :
>>
>> $sql =3D 'SELECT * FROM table WHERE id=3D"'.$var.'" ';
>> $req =3D mysql_query($sql) or die('Erreur SQL
>> !
'.$sql.'
'.mysql_error());
>> while($data =3D mysql_fetch_assoc($req)) {
>> echo $data['id'];
>> }
>> $sql2 =3D 'DELETE FROM table WHERE id=3D"'.$var.'" ';
>> $req2 =3D mysql_query($sql2) or die('Erreur SQL
>> !
'.$sql2.'
'.mysql_error());
>>
>>
>> Results of this queries :
>>
>> In first case (it works) : I see the id get in mysql and it delete it
>> after
>>
>> In second case (it don't work) : I don't see id get in mysql. It's
>> like if it delete it first and after select.
>>
>> I have not error in php log.
>>
>>
>> If somebody can help me, because I try since few hours...
>>
>>
>> Best regards,
>>
>> David DURIEUX
>> Tel : +33 (0)4.74.04.81.34
>> Port : +33 (0)6.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>> --=20
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>=20
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

RGlkIHlvdSBhY3R1YWxseSBlY2hvIHRoZSAkc3FsPwoKSSBrbm93IGl0IHdv cmtzIHJpZ2h0IG5v
dywgYnV0IHRyeSB0byB0YWtlIGF3YXkgdGhlIHF1b3RlcyBhcm91bmQgdGhl CnZhbHVlIGluIHRo
ZSBxdWVyeSBhbmQgc2VlIGlmIHNvbWV0aGluZyBoYXBwZW5zOgoKJHNxbCA9 ICJTRUxFQ1QgKiBG
Uk9NIHRhYmxlIFdIRVJFIGlkPXskdmFyfSI7CgpJZiB0aGF0IGRvZXNuJ3Qg d29yayB0aGVuIHZh
cl9kdW1wKCRzcWwsICR2YXIpIGFuZCB3cml0ZSB1cyB0aGUKcmVzdWx0LiBB bHNvIGxldCB1cyBr
bm93IHRoZSBkYXRhIHR5cGUgb2YgdGhlIElEIGNvbHVtbi4KCk9uIFdlZCwg U2VwIDMsIDIwMDgg
YXQgMTE6MjEgQU0sIERhdmlkIERVUklFVVggPGQuZHVyaWV1eEBzaXByb3Nz aWkuY29tPiB3cm90
ZToKPiBBdCB0aGUgYmVnaW5pbmcgJHZhciBpcyAkX0dFVFsnaWQnXSBhbmQg YWZ0ZXIgSSB0cnkg
ZGlyZWN0bHkgJHZhciA9IDEwCj4gYnV0IG5vIGNoYW5nZXMuCj4KPiBPbiB0 aGUgc2VydmVyIGRp
cmVjdGx5LCBJIGNhbiBvbmx5IHRyeSB3aXRoIHRoZSB2YWx1ZXMgIDoKPiAk c3FsID0gJ1NFTEVD
VCAqIEZST00gdGFibGUgV0hFUkUgaWQ9IjEwIiAnOyBhbmQgZm9yIHRoaXMg bm8gcHJvYmxlbS4K
Pgo+IFRoZSBwcm9ibGVtIGlzIHdoZW4gSSB1c2UgYSB2YXJpYWJsZSBpbiBx dWVyeQo+Cj4KPiBC
ZXN0IHJlZ2FyZHMsCj4KPiBEYXZpZCBEVVJJRVVYCj4gVGVsIDogMDQuNzQu MDQuODEuMzQKPiBQ
b3J0IDogMDYuMzQuOTkuNDUuMTgKPiBNYWlsIDogZC5kdXJpZXV4QHNpcHJv c3NpaS5jb20KPiBT
aXRlIFdlYiA6IGh0dHA6Ly93d3cuc2lwcm9zc2lpLmNvbS8KPgo+IFNJUFJP U1NJSQo+IDg0NyBy
b3V0ZSBkZSBGcmFucyAoQ3LDqWFjaXTDqSkKPiA2OTQwMCBWaWxsZWZyYW5j aGUgc3VyIFNhw7Ru
ZQo+Cj4KPgo+IExlIFdlZCwgMyBTZXAgMjAwOCAxMToxMzoxMSArMDIwMAo+ ICJFdmVydCBMYW1t
ZXJ0cyIgPGV2ZXJ0LmxhbW1lcnRzQGdtYWlsLmNvbT4gYSDDqWNyaXQ6Cj4K Pj4+ICRzcWwgPSAn
U0VMRUNUICogRlJPTSB0YWJsZSBXSEVSRSBpZD0iJy4kdmFyLiciICc7Cj4+ PiAkcmVxID0gbXlz
cWxfcXVlcnkoJHNxbCkgb3IgZGllKCdFcnJldXIgU1FMCj4+PiAhPGJyPicu JHNxbC4nPGJyPicu
bXlzcWxfZXJyb3IoKSk7Cj4+PiB3aGlsZSgkZGF0YSA9IG15c3FsX2ZldGNo X2Fzc29jKCRyZXEp
KSB7Cj4+PiAgZWNobyAkZGF0YVsnaWQnXTsKPj4+IH0KPj4+ICRzcWwyID0g J0RFTEVURSBGUk9N
IHRhYmxlIFdIRVJFIGlkPSInLiR2YXIuJyIgJzsKPj4+ICRyZXEyID0gbXlz cWxfcXVlcnkoJHNx
bDIpIG9yIGRpZSgnRXJyZXVyIFNRTAo+Pj4gITxicj4nLiRzcWwyLic8YnI+ Jy5teXNxbF9lcnJv
cigpKTsKPj4KPj5JJ2xsIGFzayB0aGUgb2J2aW91czogd2hlcmUgYW5kIGhv dyBpcyAkdmFyIHNl
dCwgYW5kIGRpZCB5b3UgZWNobyB5b3VyCj4+JHNxbCB2YXJpYWJsZSB0byB0 cnkgdGhlIHF1ZXJ5
IG9uIHlvdXIgbXlzcWwgc2VydmVyIGRpcmVjdGx5Pwo+Pgo+Cj4KPiAtLQo+ IFBIUCBEYXRhYmFz
ZSBNYWlsaW5nIExpc3QgKGh0dHA6Ly93d3cucGhwLm5ldC8pCj4gVG8gdW5z dWJzY3JpYmUsIHZp
c2l0OiBodHRwOi8vd3d3LnBocC5uZXQvdW5zdWIucGhwCj4KPgo=

Re: Probleme with MySQL queries

Bonjour,

No changes :/=20
I have always the same things

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 11:29:29 +0200
"Evert Lammerts" a =E9crit:

>Did you actually echo the $sql?
>
>I know it works right now, but try to take away the quotes around the
>value in the query and see if something happens:
>
>$sql =3D "SELECT * FROM table WHERE id=3D{$var}";
>
>If that doesn't work then var_dump($sql, $var) and write us the
>result. Also let us know the data type of the ID column.
>
>On Wed, Sep 3, 2008 at 11:21 AM, David DURIEUX
> wrote:
>> At the begining $var is $_GET['id'] and after I try directly $var =3D
>> 10 but no changes.
>>
>> On the server directly, I can only try with the values :
>> $sql =3D 'SELECT * FROM table WHERE id=3D"10" '; and for this no problem.
>>
>> The problem is when I use a variable in query
>>
>>
>> Best regards,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>>
>> Le Wed, 3 Sep 2008 11:13:11 +0200
>> "Evert Lammerts" a =E9crit:
>>
>>>> $sql =3D 'SELECT * FROM table WHERE id=3D"'.$var.'" ';
>>>> $req =3D mysql_query($sql) or die('Erreur SQL
>>>> !
'.$sql.'
'.mysql_error());
>>>> while($data =3D mysql_fetch_assoc($req)) {
>>>> echo $data['id'];
>>>> }
>>>> $sql2 =3D 'DELETE FROM table WHERE id=3D"'.$var.'" ';
>>>> $req2 =3D mysql_query($sql2) or die('Erreur SQL
>>>> !
'.$sql2.'
'.mysql_error());
>>>
>>>I'll ask the obvious: where and how is $var set, and did you echo
>>>your $sql variable to try the query on your mysql server directly?
>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

>>If that doesn't work then var_dump($sql, $var) and write us the
>>result. Also let us know the data type of the ID column.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,


string(40) "SELECT * FROM table WHERE id=3D107 "=20
string(3) "107"
string(38) "DELETE FROM table WHERE id=3D107 "=20
string(3) "107"=20



Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 11:37:37 +0200
"Evert Lammerts" a =E9crit:

>>>If that doesn't work then var_dump($sql, $var) and write us the
>>>result. Also let us know the data type of the ID column.
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

What does mysql_error return?

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



David DURIEUX wrote:
> Bonjour,
>
>
> string(40) "SELECT * FROM table WHERE id=107 "
> string(3) "107"
> string(38) "DELETE FROM table WHERE id=107 "
> string(3) "107"
>
>
>
> Cordialement,
>
> David DURIEUX
> Tel : 04.74.04.81.34
> Port : 06.34.99.45.18
> Mail : d.durieux@siprossii.com
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 11:37:37 +0200
> "Evert Lammerts" a écrit:
>
>
>>>> If that doesn't work then var_dump($sql, $var) and write us the
>>>> result. Also let us know the data type of the ID column.
>>>>
>
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

> string(40) "SELECT * FROM table WHERE id=107 "
> string(3) "107"

And this query works when you run it on the database directly? Id 107 exists?

Assuming that that's both so we're running out of options.

After the select, can you do a print of mysql_error() and of mysql_num_rows()?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

No error for mysql_error for all 2 queries.

In fact the first return 0 results

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 03 Sep 2008 04:58:07 -0500
Micah Gersten a =E9crit:

>What does mysql_error return?
>
>Thank you,
>Micah Gersten
>onShore Networks
>Internal Developer
>http://www.onshore.com
>
>
>
>David DURIEUX wrote:
>> Bonjour,
>>
>>
>> string(40) "SELECT * FROM table WHERE id=3D107 "=20
>> string(3) "107"
>> string(38) "DELETE FROM table WHERE id=3D107 "=20
>> string(3) "107"=20
>>
>>
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>>
>> Le Wed, 3 Sep 2008 11:37:37 +0200
>> "Evert Lammerts" a =E9crit:
>>
>> =20
>>>>> If that doesn't work then var_dump($sql, $var) and write us the
>>>>> result. Also let us know the data type of the ID column.
>>>>> =20
>>
>>
>> =20
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

> In fact the first return 0 results

So the problem is in your select, and if your select works when you
manually insert the value for id (iow, without using $var), the
problem has something to do with $var.

Is the data type of the ID column INT? Try the following and let us
know the output:

$var=107;
$query = mysql_query("SELECT * FROM table WHERE id={$var};") or
die(mysql_error()); // make sure to use double quotes
var_dump(mysql_error(), mysql_num_rows());

$var=mysql_real_escape_string("107");
$query = mysql_query("SELECT * FROM table WHERE id={$var};") or
die(mysql_error()); // make sure to use double quotes
var_dump(mysql_error(), mysql_num_rows());

$query = mysql_query("SELECT * FROM table WHERE id=107;") or
die(mysql_error()); // make sure to use double quotes
var_dump(mysql_error(), mysql_num_rows());

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,



Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne

ID is INT. It's ok before.

I have errors :=20


Warning: Wrong parameter count for mysql_num_rows()
in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
on line 7 string(0) "" NULL

Warning: Wrong parameter count for mysql_num_rows()
in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
on line 12 string(0) "" NULL

Warning: Wrong parameter count for mysql_num_rows()
in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
on line 16 string(0) "" NULL=20



Le Wed, 3 Sep 2008 12:11:00 +0200
"Evert Lammerts" a =E9crit:

>> In fact the first return 0 results
>
>So the problem is in your select, and if your select works when you
>manually insert the value for id (iow, without using $var), the
>problem has something to do with $var.
>
>Is the data type of the ID column INT? Try the following and let us
>know the output:
>
>$var=3D107;
>$query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};") or
>die(mysql_error()); // make sure to use double quotes
>var_dump(mysql_error(), mysql_num_rows());
>
>$var=3Dmysql_real_escape_string("107");
>$query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};") or
>die(mysql_error()); // make sure to use double quotes
>var_dump(mysql_error(), mysql_num_rows());
>
>$query =3D mysql_query("SELECT * FROM table WHERE id=3D107;") or
>die(mysql_error()); // make sure to use double quotes
>var_dump(mysql_error(), mysql_num_rows());
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

You have to pass mysql_num_rows a $result variable from your query.

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



David DURIEUX wrote:
> Bonjour,
>
>
>
> Cordialement,
>
> David DURIEUX
> Tel : 04.74.04.81.34
> Port : 06.34.99.45.18
> Mail : d.durieux@siprossii.com
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
> ID is INT. It's ok before.
>
> I have errors :
>
>
> Warning: Wrong parameter count for mysql_num_rows()
> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
> on line 7 string(0) "" NULL
>
> Warning: Wrong parameter count for mysql_num_rows()
> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
> on line 12 string(0) "" NULL
>
> Warning: Wrong parameter count for mysql_num_rows()
> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
> on line 16 string(0) "" NULL
>
>
>
> Le Wed, 3 Sep 2008 12:11:00 +0200
> "Evert Lammerts" a écrit:
>
>
>>> In fact the first return 0 results
>>>
>> So the problem is in your select, and if your select works when you
>> manually insert the value for id (iow, without using $var), the
>> problem has something to do with $var.
>>
>> Is the data type of the ID column INT? Try the following and let us
>> know the output:
>>
>> $var=107;
>> $query = mysql_query("SELECT * FROM table WHERE id={$var};") or
>> die(mysql_error()); // make sure to use double quotes
>> var_dump(mysql_error(), mysql_num_rows());
>>
>> $var=mysql_real_escape_string("107");
>> $query = mysql_query("SELECT * FROM table WHERE id={$var};") or
>> die(mysql_error()); // make sure to use double quotes
>> var_dump(mysql_error(), mysql_num_rows());
>>
>> $query = mysql_query("SELECT * FROM table WHERE id=107;") or
>> die(mysql_error()); // make sure to use double quotes
>> var_dump(mysql_error(), mysql_num_rows());
>>
>>
>
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

TXkgYmFkLCBpdCBzaG91bGQgaGF2ZSB0aGUgcXVlcnkgaGFuZGxlIGFzIGEg cGFyYW1ldGVyIG9m
IGNvdXJzZToKCiR2YXI9MTA3OwokcXVlcnkgPSBteXNxbF9xdWVyeSgiU0VM RUNUICogRlJPTSB0
YWJsZSBXSEVSRSBpZD17JHZhcn07Iikgb3IKZGllKG15c3FsX2Vycm9yKCkp OyAvLyBtYWtlIHN1
cmUgdG8gdXNlIGRvdWJsZSBxdW90ZXMKdmFyX2R1bXAobXlzcWxfZXJyb3Io KSwgbXlzcWxfbnVt
X3Jvd3MoJHF1ZXJ5KSk7CgokdmFyPW15c3FsX3JlYWxfZXNjYXBlX3N0cmlu ZygiMTA3Iik7CiRx
dWVyeSA9IG15c3FsX3F1ZXJ5KCJTRUxFQ1QgKiBGUk9NIHRhYmxlIFdIRVJF IGlkPXskdmFyfTsi
KSBvcgpkaWUobXlzcWxfZXJyb3IoKSk7IC8vIG1ha2Ugc3VyZSB0byB1c2Ug ZG91YmxlIHF1b3Rl
cwp2YXJfZHVtcChteXNxbF9lcnJvcigpLCBteXNxbF9udW1fcm93cygkcXVl cnkpKTsKCiRxdWVy
eSA9IG15c3FsX3F1ZXJ5KCJTRUxFQ1QgKiBGUk9NIHRhYmxlIFdIRVJFIGlk PTEwNzsiKSBvcgpk
aWUobXlzcWxfZXJyb3IoKSk7IC8vIG1ha2Ugc3VyZSB0byB1c2UgZG91Ymxl IHF1b3Rlcwp2YXJf
ZHVtcChteXNxbF9lcnJvcigpLCBteXNxbF9udW1fcm93cygkcXVlcnkpKTsK Ck9uIFdlZCwgU2Vw
IDMsIDIwMDggYXQgMTI6MjEgUE0sIERhdmlkIERVUklFVVggPGQuZHVyaWV1 eEBzaXByb3NzaWku
Y29tPiB3cm90ZToKPiBCb25qb3VyLAo+Cj4KPgo+IENvcmRpYWxlbWVudCwK Pgo+IERhdmlkIERV
UklFVVgKPiBUZWwgOiAwNC43NC4wNC44MS4zNAo+IFBvcnQgOiAwNi4zNC45 OS40NS4xOAo+IE1h
aWwgOiBkLmR1cmlldXhAc2lwcm9zc2lpLmNvbQo+IFNpdGUgV2ViIDogaHR0 cDovL3d3dy5zaXBy
b3NzaWkuY29tLwo+Cj4gU0lQUk9TU0lJCj4gODQ3IHJvdXRlIGRlIEZyYW5z IChDcsOpYWNpdMOp
KQo+IDY5NDAwIFZpbGxlZnJhbmNoZSBzdXIgU2HDtG5lCj4KPiBJRCBpcyBJ TlQuIEl0J3Mgb2sg
YmVmb3JlLgo+Cj4gSSBoYXZlIGVycm9ycyA6Cj4KPgo+IFdhcm5pbmc6IFdy b25nIHBhcmFtZXRl
ciBjb3VudCBmb3IgbXlzcWxfbnVtX3Jvd3MoKQo+IGluIC91c3IvaG9tZS9z aXRlcy9DTDAwMDAw
MS9XZWJfZGF0YS9oZWJlcmdlbWVudC9wYWdlcy9zb3VzZG9tYWluZXMucGhw Cj4gb24gbGluZSA3
IHN0cmluZygwKSAiIiBOVUxMCj4KPiBXYXJuaW5nOiBXcm9uZyBwYXJhbWV0 ZXIgY291bnQgZm9y
IG15c3FsX251bV9yb3dzKCkKPiBpbiAvdXNyL2hvbWUvc2l0ZXMvQ0wwMDAw MDEvV2ViX2RhdGEv
aGViZXJnZW1lbnQvcGFnZXMvc291c2RvbWFpbmVzLnBocAo+IG9uIGxpbmUg MTIgc3RyaW5nKDAp
ICIiIE5VTEwKPgo+IFdhcm5pbmc6IFdyb25nIHBhcmFtZXRlciBjb3VudCBm b3IgbXlzcWxfbnVt
X3Jvd3MoKQo+IGluIC91c3IvaG9tZS9zaXRlcy9DTDAwMDAwMS9XZWJfZGF0 YS9oZWJlcmdlbWVu
dC9wYWdlcy9zb3VzZG9tYWluZXMucGhwCj4gb24gbGluZSAxNiBzdHJpbmco MCkgIiIgTlVMTAo+
Cj4KPgo+IExlIFdlZCwgMyBTZXAgMjAwOCAxMjoxMTowMCArMDIwMAo+ICJF dmVydCBMYW1tZXJ0
cyIgPGV2ZXJ0LmxhbW1lcnRzQGdtYWlsLmNvbT4gYSDDqWNyaXQ6Cj4KPj4+ IEluIGZhY3QgdGhl
IGZpcnN0IHJldHVybiAwIHJlc3VsdHMKPj4KPj5TbyB0aGUgcHJvYmxlbSBp cyBpbiB5b3VyIHNl
bGVjdCwgYW5kIGlmIHlvdXIgc2VsZWN0IHdvcmtzIHdoZW4geW91Cj4+bWFu dWFsbHkgaW5zZXJ0
IHRoZSB2YWx1ZSBmb3IgaWQgKGlvdywgd2l0aG91dCB1c2luZyAkdmFyKSwg dGhlCj4+cHJvYmxl
bSBoYXMgc29tZXRoaW5nIHRvIGRvIHdpdGggJHZhci4KPj4KPj5JcyB0aGUg ZGF0YSB0eXBlIG9m
IHRoZSBJRCBjb2x1bW4gSU5UPyBUcnkgdGhlIGZvbGxvd2luZyBhbmQgbGV0 IHVzCj4+a25vdyB0
aGUgb3V0cHV0Ogo+Pgo+PiR2YXI9MTA3Owo+PiRxdWVyeSA9IG15c3FsX3F1 ZXJ5KCJTRUxFQ1Qg
KiBGUk9NIHRhYmxlIFdIRVJFIGlkPXskdmFyfTsiKSBvcgo+PmRpZShteXNx bF9lcnJvcigpKTsg
Ly8gbWFrZSBzdXJlIHRvIHVzZSBkb3VibGUgcXVvdGVzCj4+dmFyX2R1bXAo bXlzcWxfZXJyb3Io
KSwgbXlzcWxfbnVtX3Jvd3MoKSk7Cj4+Cj4+JHZhcj1teXNxbF9yZWFsX2Vz Y2FwZV9zdHJpbmco
IjEwNyIpOwo+PiRxdWVyeSA9IG15c3FsX3F1ZXJ5KCJTRUxFQ1QgKiBGUk9N IHRhYmxlIFdIRVJF
IGlkPXskdmFyfTsiKSBvcgo+PmRpZShteXNxbF9lcnJvcigpKTsgLy8gbWFr ZSBzdXJlIHRvIHVz
ZSBkb3VibGUgcXVvdGVzCj4+dmFyX2R1bXAobXlzcWxfZXJyb3IoKSwgbXlz cWxfbnVtX3Jvd3Mo
KSk7Cj4+Cj4+JHF1ZXJ5ID0gbXlzcWxfcXVlcnkoIlNFTEVDVCAqIEZST00g dGFibGUgV0hFUkUg
aWQ9MTA3OyIpIG9yCj4+ZGllKG15c3FsX2Vycm9yKCkpOyAvLyBtYWtlIHN1 cmUgdG8gdXNlIGRv
dWJsZSBxdW90ZXMKPj52YXJfZHVtcChteXNxbF9lcnJvcigpLCBteXNxbF9u dW1fcm93cygpKTsK
Pj4KPgo+Cj4gLS0KPiBQSFAgRGF0YWJhc2UgTWFpbGluZyBMaXN0IChodHRw Oi8vd3d3LnBocC5u
ZXQvKQo+IFRvIHVuc3Vic2NyaWJlLCB2aXNpdDogaHR0cDovL3d3dy5waHAu bmV0L3Vuc3ViLnBo
cAo+Cj4K

Re: Probleme with MySQL queries

Bonjour,

string(0) "" int(1)
string(0) "" int(1)
string(0) "" int(1)=20

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 03 Sep 2008 05:23:19 -0500
Micah Gersten a =E9crit:

>You have to pass mysql_num_rows a $result variable from your query.
>
>Thank you,
>Micah Gersten
>onShore Networks
>Internal Developer
>http://www.onshore.com
>
>
>
>David DURIEUX wrote:
>> Bonjour,
>>
>>
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>> ID is INT. It's ok before.
>>
>> I have errors :=20
>>
>>
>> Warning: Wrong parameter count for mysql_num_rows()
>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
>> on line 7 string(0) "" NULL
>>
>> Warning: Wrong parameter count for mysql_num_rows()
>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
>> on line 12 string(0) "" NULL
>>
>> Warning: Wrong parameter count for mysql_num_rows()
>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma ines.php
>> on line 16 string(0) "" NULL=20
>>
>>
>>
>> Le Wed, 3 Sep 2008 12:11:00 +0200
>> "Evert Lammerts" a =E9crit:
>>
>> =20
>>>> In fact the first return 0 results
>>>> =20
>>> So the problem is in your select, and if your select works when you
>>> manually insert the value for id (iow, without using $var), the
>>> problem has something to do with $var.
>>>
>>> Is the data type of the ID column INT? Try the following and let us
>>> know the output:
>>>
>>> $var=3D107;
>>> $query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};") or
>>> die(mysql_error()); // make sure to use double quotes
>>> var_dump(mysql_error(), mysql_num_rows());
>>>
>>> $var=3Dmysql_real_escape_string("107");
>>> $query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};") or
>>> die(mysql_error()); // make sure to use double quotes
>>> var_dump(mysql_error(), mysql_num_rows());
>>>
>>> $query =3D mysql_query("SELECT * FROM table WHERE id=3D107;") or
>>> die(mysql_error()); // make sure to use double quotes
>>> var_dump(mysql_error(), mysql_num_rows());
>>>
>>> =20
>>
>>
>> =20
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

V2hpY2ggbWVhbnMgeW91IGRvIGdldCByZXN1bHRzIGFuZCB5b3VyIHNlbGVj dCB3b3Jrcy4KCk5v
dyB0cnk6CgokdmFyPTEwNzsKJHF1ZXJ5ID0gbXlzcWxfcXVlcnkoIlNFTEVD VCAqIEZST00gdGFi
bGUgV0hFUkUgaWQ9eyR2YXJ9OyIpIG9yCmRpZShteXNxbF9lcnJvcigpKTsK CmlmICgkcm93ID0g
bXlzcWxfZmV0Y2hfYXNzb2MoJHF1ZXJ5KSkKIHZhcl9kdW1wICgkZGF0YSk7 CgokcXVlcnkgPSBt
eXNxbF9xdWVyeSgiREVMRVRFIEZST00gdGFibGUgV0hFUkUgaWQ9eyR2YXJ9 Iikgb3IgZGllKG15
c3FsX2Vycm9yKCkpOwoKT24gV2VkLCBTZXAgMywgMjAwOCBhdCAxMjoyNSBQ TSwgRGF2aWQgRFVS
SUVVWCA8ZC5kdXJpZXV4QHNpcHJvc3NpaS5jb20+IHdyb3RlOgo+IEJvbmpv dXIsCj4KPiBzdHJp
bmcoMCkgIiIgaW50KDEpCj4gc3RyaW5nKDApICIiIGludCgxKQo+IHN0cmlu ZygwKSAiIiBpbnQo
MSkKPgo+IENvcmRpYWxlbWVudCwKPgo+IERhdmlkIERVUklFVVgKPiBUZWwg OiAwNC43NC4wNC44
MS4zNAo+IFBvcnQgOiAwNi4zNC45OS40NS4xOAo+IE1haWwgOiBkLmR1cmll dXhAc2lwcm9zc2lp
LmNvbQo+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXByb3NzaWkuY29tLwo+ Cj4gU0lQUk9TU0lJ
Cj4gODQ3IHJvdXRlIGRlIEZyYW5zIChDcsOpYWNpdMOpKQo+IDY5NDAwIFZp bGxlZnJhbmNoZSBz
dXIgU2HDtG5lCj4KPgo+Cj4gTGUgV2VkLCAwMyBTZXAgMjAwOCAwNToyMzox OSAtMDUwMAo+IE1p
Y2FoIEdlcnN0ZW4gPG1pY2FoQG9uc2hvcmUuY29tPiBhIMOpY3JpdDoKPgo+ PllvdSBoYXZlIHRv
IHBhc3MgbXlzcWxfbnVtX3Jvd3MgYSAkcmVzdWx0IHZhcmlhYmxlIGZyb20g eW91ciBxdWVyeS4K
Pj4KPj5UaGFuayB5b3UsCj4+TWljYWggR2Vyc3Rlbgo+Pm9uU2hvcmUgTmV0 d29ya3MKPj5JbnRl
cm5hbCBEZXZlbG9wZXIKPj5odHRwOi8vd3d3Lm9uc2hvcmUuY29tCj4+Cj4+ Cj4+Cj4+RGF2aWQg
RFVSSUVVWCB3cm90ZToKPj4+IEJvbmpvdXIsCj4+Pgo+Pj4KPj4+Cj4+PiBD b3JkaWFsZW1lbnQs
Cj4+Pgo+Pj4gRGF2aWQgRFVSSUVVWAo+Pj4gVGVsIDogMDQuNzQuMDQuODEu MzQKPj4+IFBvcnQg
OiAwNi4zNC45OS40NS4xOAo+Pj4gTWFpbCA6IGQuZHVyaWV1eEBzaXByb3Nz aWkuY29tCj4+PiBT
aXRlIFdlYiA6IGh0dHA6Ly93d3cuc2lwcm9zc2lpLmNvbS8KPj4+Cj4+PiBT SVBST1NTSUkKPj4+
IDg0NyByb3V0ZSBkZSBGcmFucyAoQ3LDqWFjaXTDqSkKPj4+IDY5NDAwIFZp bGxlZnJhbmNoZSBz
dXIgU2HDtG5lCj4+Pgo+Pj4gSUQgaXMgSU5ULiBJdCdzIG9rIGJlZm9yZS4K Pj4+Cj4+PiBJIGhh
dmUgZXJyb3JzIDoKPj4+Cj4+Pgo+Pj4gV2FybmluZzogV3JvbmcgcGFyYW1l dGVyIGNvdW50IGZv
ciBteXNxbF9udW1fcm93cygpCj4+PiBpbiAvdXNyL2hvbWUvc2l0ZXMvQ0ww MDAwMDEvV2ViX2Rh
dGEvaGViZXJnZW1lbnQvcGFnZXMvc291c2RvbWFpbmVzLnBocAo+Pj4gb24g bGluZSA3IHN0cmlu
ZygwKSAiIiBOVUxMCj4+Pgo+Pj4gV2FybmluZzogV3JvbmcgcGFyYW1ldGVy IGNvdW50IGZvciBt
eXNxbF9udW1fcm93cygpCj4+PiBpbiAvdXNyL2hvbWUvc2l0ZXMvQ0wwMDAw MDEvV2ViX2RhdGEv
aGViZXJnZW1lbnQvcGFnZXMvc291c2RvbWFpbmVzLnBocAo+Pj4gb24gbGlu ZSAxMiBzdHJpbmco
MCkgIiIgTlVMTAo+Pj4KPj4+IFdhcm5pbmc6IFdyb25nIHBhcmFtZXRlciBj b3VudCBmb3IgbXlz
cWxfbnVtX3Jvd3MoKQo+Pj4gaW4gL3Vzci9ob21lL3NpdGVzL0NMMDAwMDAx L1dlYl9kYXRhL2hl
YmVyZ2VtZW50L3BhZ2VzL3NvdXNkb21haW5lcy5waHAKPj4+IG9uIGxpbmUg MTYgc3RyaW5nKDAp
ICIiIE5VTEwKPj4+Cj4+Pgo+Pj4KPj4+IExlIFdlZCwgMyBTZXAgMjAwOCAx MjoxMTowMCArMDIw
MAo+Pj4gIkV2ZXJ0IExhbW1lcnRzIiA8ZXZlcnQubGFtbWVydHNAZ21haWwu Y29tPiBhIMOpY3Jp
dDoKPj4+Cj4+Pgo+Pj4+PiBJbiBmYWN0IHRoZSBmaXJzdCByZXR1cm4gMCBy ZXN1bHRzCj4+Pj4+
Cj4+Pj4gU28gdGhlIHByb2JsZW0gaXMgaW4geW91ciBzZWxlY3QsIGFuZCBp ZiB5b3VyIHNlbGVj
dCB3b3JrcyB3aGVuIHlvdQo+Pj4+IG1hbnVhbGx5IGluc2VydCB0aGUgdmFs dWUgZm9yIGlkIChp
b3csIHdpdGhvdXQgdXNpbmcgJHZhciksIHRoZQo+Pj4+IHByb2JsZW0gaGFz IHNvbWV0aGluZyB0
byBkbyB3aXRoICR2YXIuCj4+Pj4KPj4+PiBJcyB0aGUgZGF0YSB0eXBlIG9m IHRoZSBJRCBjb2x1
bW4gSU5UPyBUcnkgdGhlIGZvbGxvd2luZyBhbmQgbGV0IHVzCj4+Pj4ga25v dyB0aGUgb3V0cHV0
Ogo+Pj4+Cj4+Pj4gJHZhcj0xMDc7Cj4+Pj4gJHF1ZXJ5ID0gbXlzcWxfcXVl cnkoIlNFTEVDVCAq
IEZST00gdGFibGUgV0hFUkUgaWQ9eyR2YXJ9OyIpIG9yCj4+Pj4gZGllKG15 c3FsX2Vycm9yKCkp
OyAvLyBtYWtlIHN1cmUgdG8gdXNlIGRvdWJsZSBxdW90ZXMKPj4+PiB2YXJf ZHVtcChteXNxbF9l
cnJvcigpLCBteXNxbF9udW1fcm93cygpKTsKPj4+Pgo+Pj4+ICR2YXI9bXlz cWxfcmVhbF9lc2Nh
cGVfc3RyaW5nKCIxMDciKTsKPj4+PiAkcXVlcnkgPSBteXNxbF9xdWVyeSgi U0VMRUNUICogRlJP
TSB0YWJsZSBXSEVSRSBpZD17JHZhcn07Iikgb3IKPj4+PiBkaWUobXlzcWxf ZXJyb3IoKSk7IC8v
IG1ha2Ugc3VyZSB0byB1c2UgZG91YmxlIHF1b3Rlcwo+Pj4+IHZhcl9kdW1w KG15c3FsX2Vycm9y
KCksIG15c3FsX251bV9yb3dzKCkpOwo+Pj4+Cj4+Pj4gJHF1ZXJ5ID0gbXlz cWxfcXVlcnkoIlNF
TEVDVCAqIEZST00gdGFibGUgV0hFUkUgaWQ9MTA3OyIpIG9yCj4+Pj4gZGll KG15c3FsX2Vycm9y
KCkpOyAvLyBtYWtlIHN1cmUgdG8gdXNlIGRvdWJsZSBxdW90ZXMKPj4+PiB2 YXJfZHVtcChteXNx
bF9lcnJvcigpLCBteXNxbF9udW1fcm93cygpKTsKPj4+Pgo+Pj4+Cj4+Pgo+ Pj4KPj4+Cj4+Cj4K
Pgo+IC0tCj4gUEhQIERhdGFiYXNlIE1haWxpbmcgTGlzdCAoaHR0cDovL3d3 dy5waHAubmV0LykK
PiBUbyB1bnN1YnNjcmliZSwgdmlzaXQ6IGh0dHA6Ly93d3cucGhwLm5ldC91 bnN1Yi5waHAKPgo+
Cg==

Re: Probleme with MySQL queries

V2hhdCBkb2VzIHZhcl9kdW1wKCRfR0VUKSBzYXk/CgpPbiBXZWQsIFNlcCAz LCAyMDA4IGF0IDEy
OjQ4IFBNLCBEYXZpZCBEVVJJRVVYIDxkLmR1cmlldXhAc2lwcm9zc2lpLmNv bT4gd3JvdGU6Cj4g
Qm9uam91ciwKPgo+IFRoZSBxdWVyeSB3b3Jrcwo+Cj4gQnV0IHdoZW4gSSB3 cm90ZSB0aGlzIDoK
Pgo+Cj4gaWYgKGlzc2V0KCRfR0VUWydkZWxldGVpZCddKSl7Cj4KPiAgICAg ICAgJHZhcj0xMDg7
Cj4gICAgICAgICRxdWVyeSA9IG15c3FsX3F1ZXJ5KCJTRUxFQ1QgKiBGUk9N IHRhYmxlIFdIRVJF
IGlkPXskdmFyfTsiKSBvcgo+ICAgICAgICBkaWUoInNlbGVjdCBlcnJvcjog IiAuIG15c3FsX2Vy
cm9yKCkpOwo+Cj4gICAgICAgIGlmICgkcm93ID0gbXlzcWxfZmV0Y2hfYXNz b2MoJHF1ZXJ5KSkK
PiAgICAgICAgdmFyX2R1bXAgKCRyb3cpOwo+Cj4gICAgICAgICRxdWVyeSA9 IG15c3FsX3F1ZXJ5
KCJERUxFVEUgRlJPTSB0YWJsZSBXSEVSRSBpZD17JHZhcn0iKSBvcgo+ICAg ICAgICBkaWUoImRl
bGV0ZSBlcnJvcjogIiAuIG15c3FsX2Vycm9yKCkpOwo+Cj4KPiB9Cj4KPgo+ IEl0IG5vdCB3b3Jr
cyBhbmQgbm8gcmV0dXJuIGFuZCBubyBlcnJvciAuCj4KPiBJZiBJIHBsYWNl IHRoZSBxdWVyeSB5
b3UgaGF2ZSBzZW50IG1lIHdpdGhvdXQgdGhlIGlmIGl0IHdvcmtzIGJ1dCBJ Cj4gbXVzdCBoYXZl
IGEgaWYgZm9yIGRlbGV0ZSB0aGUgSUQKPgo+IEl0IGlzIHZlcnkgc3RyYW5n ZQo+Cj4gQ29yZGlh
bGVtZW50LAo+Cj4gRGF2aWQgRFVSSUVVWAo+IFRlbCA6IDA0Ljc0LjA0Ljgx LjM0Cj4gUG9ydCA6
IDA2LjM0Ljk5LjQ1LjE4Cj4gTWFpbCA6IGQuZHVyaWV1eEBzaXByb3NzaWku Y29tCj4gU2l0ZSBX
ZWIgOiBodHRwOi8vd3d3LnNpcHJvc3NpaS5jb20vCj4KPiBTSVBST1NTSUkK PiA4NDcgcm91dGUg
ZGUgRnJhbnMgKENyw6lhY2l0w6kpCj4gNjk0MDAgVmlsbGVmcmFuY2hlIHN1 ciBTYcO0bmUKPgo+
Cj4KPiBMZSBXZWQsIDMgU2VwIDIwMDggMTI6Mzk6NDUgKzAyMDAKPiAiRXZl cnQgTGFtbWVydHMi
IDxldmVydC5sYW1tZXJ0c0BnbWFpbC5jb20+IGEgw6ljcml0Ogo+Cj4+Rml4 ZWQgdGhlbj8KPj4K
Pj5PbiBXZWQsIFNlcCAzLCAyMDA4IGF0IDEyOjM5IFBNLCBEYXZpZCBEVVJJ RVVYCj4+PGQuZHVy
aWV1eEBzaXByb3NzaWkuY29tPiB3cm90ZToKPj4+IEJvbmpvdXIsCj4+Pgo+ Pj4gWWVzIEkgaGF2
ZSB0aGUgdmFsdWVzCj4+Pgo+Pj4gYXJyYXkoNSkgeyBbImlkIl09PiAgc3Ry aW5nKDMpICIxMjEi
IFsiZG9tYWluZSJdPT4gIHN0cmluZygxKQo+Pj4gIjEiIFsic291c19kb21h aW5lIl09PiAgc3Ry
aW5nKDgpICJhYWFhYWFhYSIgWyJyZXBlcnRvaXJlIl09Pgo+Pj4gc3RyaW5n KDApICIiIFsicmVk
aXJlY3Rpb24iXT0+ICBzdHJpbmcoMSkgIjAiIH0KPj4+Cj4+Pgo+Pj4gQ29y ZGlhbGVtZW50LAo+
Pj4KPj4+IERhdmlkIERVUklFVVgKPj4+IFRlbCA6IDA0Ljc0LjA0LjgxLjM0 Cj4+PiBQb3J0IDog
MDYuMzQuOTkuNDUuMTgKPj4+IE1haWwgOiBkLmR1cmlldXhAc2lwcm9zc2lp LmNvbQo+Pj4gU2l0
ZSBXZWIgOiBodHRwOi8vd3d3LnNpcHJvc3NpaS5jb20vCj4+Pgo+Pj4gU0lQ Uk9TU0lJCj4+PiA4
NDcgcm91dGUgZGUgRnJhbnMgKENyw6lhY2l0w6kpCj4+PiA2OTQwMCBWaWxs ZWZyYW5jaGUgc3Vy
IFNhw7RuZQo+Pj4KPj4+Cj4+Pgo+Pj4gTGUgV2VkLCAzIFNlcCAyMDA4IDEy OjM2OjQzICswMjAw
Cj4+PiAiRXZlcnQgTGFtbWVydHMiIDxldmVydC5sYW1tZXJ0c0BnbWFpbC5j b20+IGEgw6ljcml0
Ogo+Pj4KPj4+Pkkga2VlcCBvbiBtYWtpbmcgbWlzdGFrZXMuICRkYXRhIHNo b3VsZCBiZSAkcm93
IGluIHRoZSB2YXJfZHVtcCAtIGJ1dAo+Pj4+cmlnaHQgbm93IHlvdXIgREVM RVRFIGhhcyBhbHJl
YWR5IGRlbGV0ZWQgaWQgMTcgKHRoZSBmYWN0IHRoYXQgaXQKPj4+PnByaW50 cyBOVUxMIG1lYW5z
IHRoZSBpZiBjb25kaXRpb24gd2FzIHNhdGlzZmllZCkuIFNvIHJlcGxhY2Ug dGhlCj4+Pj5iZWxv
dyBjb2RlIHdpdGggYSBkaWZmZXJlbnQgJHZhciB2YWx1ZToKPj4+Pgo+Pj4+ JHZhcj0xMDc7Cj4+
Pj4kcXVlcnkgPSBteXNxbF9xdWVyeSgiU0VMRUNUICogRlJPTSB0YWJsZSBX SEVSRSBpZD17JHZh
cn07Iikgb3IKPj4+PmRpZSgic2VsZWN0IGVycm9yOiAiIC4gbXlzcWxfZXJy b3IoKSk7Cj4+Pj4K
Pj4+PmlmICgkcm93ID0gbXlzcWxfZmV0Y2hfYXNzb2MoJHF1ZXJ5KSkKPj4+ PiB2YXJfZHVtcCAo
JHJvdyk7Cj4+Pj4KPj4+PiRxdWVyeSA9IG15c3FsX3F1ZXJ5KCJERUxFVEUg RlJPTSB0YWJsZSBX
SEVSRSBpZD17JHZhcn0iKSBvcgo+Pj4+ZGllKCJkZWxldGUgZXJyb3I6ICIg LiBteXNxbF9lcnJv
cigpKTsKPj4+Pgo+Pj4+T24gV2VkLCBTZXAgMywgMjAwOCBhdCAxMjozMyBQ TSwgRGF2aWQgRFVS
SUVVWAo+Pj4+PGQuZHVyaWV1eEBzaXByb3NzaWkuY29tPiB3cm90ZToKPj4+ Pj4gQm9uam91ciwK
Pj4+Pj4KPj4+Pj4gSSBoYXZlIDoKPj4+Pj4KPj4+Pj4gTlVMTAo+Pj4+Pgo+ Pj4+Pgo+Pj4+Pgo+
Pj4+PiBDb3JkaWFsZW1lbnQsCj4+Pj4+Cj4+Pj4+IERhdmlkIERVUklFVVgK Pj4+Pj4gVGVsIDog
MDQuNzQuMDQuODEuMzQKPj4+Pj4gUG9ydCA6IDA2LjM0Ljk5LjQ1LjE4Cj4+ Pj4+IE1haWwgOiBk
LmR1cmlldXhAc2lwcm9zc2lpLmNvbQo+Pj4+PiBTaXRlIFdlYiA6IGh0dHA6 Ly93d3cuc2lwcm9z
c2lpLmNvbS8KPj4+Pj4KPj4+Pj4gU0lQUk9TU0lJCj4+Pj4+IDg0NyByb3V0 ZSBkZSBGcmFucyAo
Q3LDqWFjaXTDqSkKPj4+Pj4gNjk0MDAgVmlsbGVmcmFuY2hlIHN1ciBTYcO0 bmUKPj4+Pj4KPj4+
Pj4KPj4+Pj4KPj4+Pj4gTGUgV2VkLCAzIFNlcCAyMDA4IDEyOjI5OjQ0ICsw MjAwCj4+Pj4+ICJF
dmVydCBMYW1tZXJ0cyIgPGV2ZXJ0LmxhbW1lcnRzQGdtYWlsLmNvbT4gYSDD qWNyaXQ6Cj4+Pj4+
Cj4+Pj4+PldoaWNoIG1lYW5zIHlvdSBkbyBnZXQgcmVzdWx0cyBhbmQgeW91 ciBzZWxlY3Qgd29y
a3MuCj4+Pj4+Pgo+Pj4+Pj5Ob3cgdHJ5Ogo+Pj4+Pj4KPj4+Pj4+JHZhcj0x MDc7Cj4+Pj4+PiRx
dWVyeSA9IG15c3FsX3F1ZXJ5KCJTRUxFQ1QgKiBGUk9NIHRhYmxlIFdIRVJF IGlkPXskdmFyfTsi
KSBvcgo+Pj4+Pj5kaWUobXlzcWxfZXJyb3IoKSk7Cj4+Pj4+Pgo+Pj4+Pj5p ZiAoJHJvdyA9IG15
c3FsX2ZldGNoX2Fzc29jKCRxdWVyeSkpCj4+Pj4+PiB2YXJfZHVtcCAoJGRh dGEpOwo+Pj4+Pj4K
Pj4+Pj4+JHF1ZXJ5ID0gbXlzcWxfcXVlcnkoIkRFTEVURSBGUk9NIHRhYmxl IFdIRVJFIGlkPXsk
dmFyfSIpIG9yCj4+Pj4+PmRpZShteXNxbF9lcnJvcigpKTsKPj4+Pj4+Cj4+ Pj4+Pk9uIFdlZCwg
U2VwIDMsIDIwMDggYXQgMTI6MjUgUE0sIERhdmlkIERVUklFVVgKPj4+Pj4+ PGQuZHVyaWV1eEBz
aXByb3NzaWkuY29tPiB3cm90ZToKPj4+Pj4+PiBCb25qb3VyLAo+Pj4+Pj4+ Cj4+Pj4+Pj4gc3Ry
aW5nKDApICIiIGludCgxKQo+Pj4+Pj4+IHN0cmluZygwKSAiIiBpbnQoMSkK Pj4+Pj4+PiBzdHJp
bmcoMCkgIiIgaW50KDEpCj4+Pj4+Pj4KPj4+Pj4+PiBDb3JkaWFsZW1lbnQs Cj4+Pj4+Pj4KPj4+
Pj4+PiBEYXZpZCBEVVJJRVVYCj4+Pj4+Pj4gVGVsIDogMDQuNzQuMDQuODEu MzQKPj4+Pj4+PiBQ
b3J0IDogMDYuMzQuOTkuNDUuMTgKPj4+Pj4+PiBNYWlsIDogZC5kdXJpZXV4 QHNpcHJvc3NpaS5j
b20KPj4+Pj4+PiBTaXRlIFdlYiA6IGh0dHA6Ly93d3cuc2lwcm9zc2lpLmNv bS8KPj4+Pj4+Pgo+
Pj4+Pj4+IFNJUFJPU1NJSQo+Pj4+Pj4+IDg0NyByb3V0ZSBkZSBGcmFucyAo Q3LDqWFjaXTDqSkK
Pj4+Pj4+PiA2OTQwMCBWaWxsZWZyYW5jaGUgc3VyIFNhw7RuZQo+Pj4+Pj4+ Cj4+Pj4+Pj4KPj4+
Pj4+Pgo+Pj4+Pj4+IExlIFdlZCwgMDMgU2VwIDIwMDggMDU6MjM6MTkgLTA1 MDAKPj4+Pj4+PiBN
aWNhaCBHZXJzdGVuIDxtaWNhaEBvbnNob3JlLmNvbT4gYSDDqWNyaXQ6Cj4+ Pj4+Pj4KPj4+Pj4+
Pj5Zb3UgaGF2ZSB0byBwYXNzIG15c3FsX251bV9yb3dzIGEgJHJlc3VsdCB2 YXJpYWJsZSBmcm9t
IHlvdXIKPj4+Pj4+Pj5xdWVyeS4KPj4+Pj4+Pj4KPj4+Pj4+Pj5UaGFuayB5 b3UsCj4+Pj4+Pj4+
TWljYWggR2Vyc3Rlbgo+Pj4+Pj4+Pm9uU2hvcmUgTmV0d29ya3MKPj4+Pj4+ Pj5JbnRlcm5hbCBE
ZXZlbG9wZXIKPj4+Pj4+Pj5odHRwOi8vd3d3Lm9uc2hvcmUuY29tCj4+Pj4+ Pj4+Cj4+Pj4+Pj4+
Cj4+Pj4+Pj4+Cj4+Pj4+Pj4+RGF2aWQgRFVSSUVVWCB3cm90ZToKPj4+Pj4+ Pj4+IEJvbmpvdXIs
Cj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+Cj4+Pj4+Pj4+PiBDb3Jk aWFsZW1lbnQsCj4+
Pj4+Pj4+Pgo+Pj4+Pj4+Pj4gRGF2aWQgRFVSSUVVWAo+Pj4+Pj4+Pj4gVGVs IDogMDQuNzQuMDQu
ODEuMzQKPj4+Pj4+Pj4+IFBvcnQgOiAwNi4zNC45OS40NS4xOAo+Pj4+Pj4+ Pj4gTWFpbCA6IGQu
ZHVyaWV1eEBzaXByb3NzaWkuY29tCj4+Pj4+Pj4+PiBTaXRlIFdlYiA6IGh0 dHA6Ly93d3cuc2lw
cm9zc2lpLmNvbS8KPj4+Pj4+Pj4+Cj4+Pj4+Pj4+PiBTSVBST1NTSUkKPj4+ Pj4+Pj4+IDg0NyBy
b3V0ZSBkZSBGcmFucyAoQ3LDqWFjaXTDqSkKPj4+Pj4+Pj4+IDY5NDAwIFZp bGxlZnJhbmNoZSBz
dXIgU2HDtG5lCj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4gSUQgaXMgSU5ULiBJdCdz IG9rIGJlZm9yZS4K
Pj4+Pj4+Pj4+Cj4+Pj4+Pj4+PiBJIGhhdmUgZXJyb3JzIDoKPj4+Pj4+Pj4+ Cj4+Pj4+Pj4+Pgo+
Pj4+Pj4+Pj4gV2FybmluZzogV3JvbmcgcGFyYW1ldGVyIGNvdW50IGZvciBt eXNxbF9udW1fcm93
cygpCj4+Pj4+Pj4+PiBpbiAvdXNyL2hvbWUvc2l0ZXMvQ0wwMDAwMDEvV2Vi X2RhdGEvaGViZXJn
ZW1lbnQvcGFnZXMvc291c2RvbWFpbmVzLnBocAo+Pj4+Pj4+Pj4gb24gbGlu ZSA3IHN0cmluZygw
KSAiIiBOVUxMCj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4gV2FybmluZzogV3Jvbmcg cGFyYW1ldGVyIGNv
dW50IGZvciBteXNxbF9udW1fcm93cygpCj4+Pj4+Pj4+PiBpbiAvdXNyL2hv bWUvc2l0ZXMvQ0ww
MDAwMDEvV2ViX2RhdGEvaGViZXJnZW1lbnQvcGFnZXMvc291c2RvbWFpbmVz LnBocAo+Pj4+Pj4+
Pj4gb24gbGluZSAxMiBzdHJpbmcoMCkgIiIgTlVMTAo+Pj4+Pj4+Pj4KPj4+ Pj4+Pj4+IFdhcm5p
bmc6IFdyb25nIHBhcmFtZXRlciBjb3VudCBmb3IgbXlzcWxfbnVtX3Jvd3Mo KQo+Pj4+Pj4+Pj4g
aW4gL3Vzci9ob21lL3NpdGVzL0NMMDAwMDAxL1dlYl9kYXRhL2hlYmVyZ2Vt ZW50L3BhZ2VzL3Nv
dXNkb21haW5lcy5waHAKPj4+Pj4+Pj4+IG9uIGxpbmUgMTYgc3RyaW5nKDAp ICIiIE5VTEwKPj4+
Pj4+Pj4+Cj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+IExlIFdlZCwg MyBTZXAgMjAwOCAx
MjoxMTowMCArMDIwMAo+Pj4+Pj4+Pj4gIkV2ZXJ0IExhbW1lcnRzIiA8ZXZl cnQubGFtbWVydHNA
Z21haWwuY29tPiBhIMOpY3JpdDoKPj4+Pj4+Pj4+Cj4+Pj4+Pj4+Pgo+Pj4+ Pj4+Pj4+PiBJbiBm
YWN0IHRoZSBmaXJzdCByZXR1cm4gMCByZXN1bHRzCj4+Pj4+Pj4+Pj4+Cj4+ Pj4+Pj4+Pj4gU28g
dGhlIHByb2JsZW0gaXMgaW4geW91ciBzZWxlY3QsIGFuZCBpZiB5b3VyIHNl bGVjdCB3b3Jrcwo+
Pj4+Pj4+Pj4+IHdoZW4geW91IG1hbnVhbGx5IGluc2VydCB0aGUgdmFsdWUg Zm9yIGlkIChpb3cs
IHdpdGhvdXQgdXNpbmcKPj4+Pj4+Pj4+PiAkdmFyKSwgdGhlIHByb2JsZW0g aGFzIHNvbWV0aGlu
ZyB0byBkbyB3aXRoICR2YXIuCj4+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+PiBJcyB0 aGUgZGF0YSB0eXBl
IG9mIHRoZSBJRCBjb2x1bW4gSU5UPyBUcnkgdGhlIGZvbGxvd2luZyBhbmQK Pj4+Pj4+Pj4+PiBs
ZXQgdXMga25vdyB0aGUgb3V0cHV0Ogo+Pj4+Pj4+Pj4+Cj4+Pj4+Pj4+Pj4g JHZhcj0xMDc7Cj4+
Pj4+Pj4+Pj4gJHF1ZXJ5ID0gbXlzcWxfcXVlcnkoIlNFTEVDVCAqIEZST00g dGFibGUgV0hFUkUg
aWQ9eyR2YXJ9OyIpCj4+Pj4+Pj4+Pj4gb3IgZGllKG15c3FsX2Vycm9yKCkp OyAvLyBtYWtlIHN1
cmUgdG8gdXNlIGRvdWJsZSBxdW90ZXMKPj4+Pj4+Pj4+PiB2YXJfZHVtcCht eXNxbF9lcnJvcigp
LCBteXNxbF9udW1fcm93cygpKTsKPj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+ICR2 YXI9bXlzcWxfcmVh
bF9lc2NhcGVfc3RyaW5nKCIxMDciKTsKPj4+Pj4+Pj4+PiAkcXVlcnkgPSBt eXNxbF9xdWVyeSgi
U0VMRUNUICogRlJPTSB0YWJsZSBXSEVSRSBpZD17JHZhcn07IikKPj4+Pj4+ Pj4+PiBvciBkaWUo
bXlzcWxfZXJyb3IoKSk7IC8vIG1ha2Ugc3VyZSB0byB1c2UgZG91YmxlIHF1 b3Rlcwo+Pj4+Pj4+
Pj4+IHZhcl9kdW1wKG15c3FsX2Vycm9yKCksIG15c3FsX251bV9yb3dzKCkp Owo+Pj4+Pj4+Pj4+
Cj4+Pj4+Pj4+Pj4gJHF1ZXJ5ID0gbXlzcWxfcXVlcnkoIlNFTEVDVCAqIEZS T00gdGFibGUgV0hF
UkUgaWQ9MTA3OyIpIG9yCj4+Pj4+Pj4+Pj4gZGllKG15c3FsX2Vycm9yKCkp OyAvLyBtYWtlIHN1
cmUgdG8gdXNlIGRvdWJsZSBxdW90ZXMKPj4+Pj4+Pj4+PiB2YXJfZHVtcCht eXNxbF9lcnJvcigp
LCBteXNxbF9udW1fcm93cygpKTsKPj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+Cj4+ Pj4+Pj4+Pgo+Pj4+
Pj4+Pj4KPj4+Pj4+Pj4+Cj4+Pj4+Pj4+Cj4+Pj4+Pj4KPj4+Pj4+Pgo+Pj4+ Pj4+IC0tCj4+Pj4+
Pj4gUEhQIERhdGFiYXNlIE1haWxpbmcgTGlzdCAoaHR0cDovL3d3dy5waHAu bmV0LykKPj4+Pj4+
PiBUbyB1bnN1YnNjcmliZSwgdmlzaXQ6IGh0dHA6Ly93d3cucGhwLm5ldC91 bnN1Yi5waHAKPj4+
Pj4+Pgo+Pj4+Pj4+Cj4+Pj4+Cj4+Pj4+Cj4+Pgo+Pj4KPgo+Cg==

Re: Probleme with MySQL queries

Bonjour,

array(2) { ["module"]=3D> string(12) "sousdomaines" ["deleteid"]=3D>
string(3) "133" }


Note : The ID is good deleted but no select return

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 12:54:19 +0200
"Evert Lammerts" a =E9crit:

>What does var_dump($_GET) say?
>
>On Wed, Sep 3, 2008 at 12:48 PM, David DURIEUX
> wrote:
>> Bonjour,
>>
>> The query works
>>
>> But when I wrote this :
>>
>>
>> if (isset($_GET['deleteid'])){
>>
>> $var=3D108;
>> $query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};")
>> or die("select error: " . mysql_error());
>>
>> if ($row =3D mysql_fetch_assoc($query))
>> var_dump ($row);
>>
>> $query =3D mysql_query("DELETE FROM table WHERE id=3D{$var}") or
>> die("delete error: " . mysql_error());
>>
>>
>> }
>>
>>
>> It not works and no return and no error .
>>
>> If I place the query you have sent me without the if it works but I
>> must have a if for delete the ID
>>
>> It is very strange
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>>
>> Le Wed, 3 Sep 2008 12:39:45 +0200
>> "Evert Lammerts" a =E9crit:
>>
>>>Fixed then?
>>>
>>>On Wed, Sep 3, 2008 at 12:39 PM, David DURIEUX
>>> wrote:
>>>> Bonjour,
>>>>
>>>> Yes I have the values
>>>>
>>>> array(5) { ["id"]=3D> string(3) "121" ["domaine"]=3D> string(1)
>>>> "1" ["sous_domaine"]=3D> string(8) "aaaaaaaa" ["repertoire"]=3D>
>>>> string(0) "" ["redirection"]=3D> string(1) "0" }
>>>>
>>>>
>>>> Cordialement,
>>>>
>>>> David DURIEUX
>>>> Tel : 04.74.04.81.34
>>>> Port : 06.34.99.45.18
>>>> Mail : d.durieux@siprossii.com
>>>> Site Web : http://www.siprossii.com/
>>>>
>>>> SIPROSSII
>>>> 847 route de Frans (Cr=E9acit=E9)
>>>> 69400 Villefranche sur Sa=F4ne
>>>>
>>>>
>>>>
>>>> Le Wed, 3 Sep 2008 12:36:43 +0200
>>>> "Evert Lammerts" a =E9crit:
>>>>
>>>>>I keep on making mistakes. $data should be $row in the var_dump -
>>>>>but right now your DELETE has already deleted id 17 (the fact that
>>>>>it prints NULL means the if condition was satisfied). So replace
>>>>>the below code with a different $var value:
>>>>>
>>>>>$var=3D107;
>>>>>$query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};") or
>>>>>die("select error: " . mysql_error());
>>>>>
>>>>>if ($row =3D mysql_fetch_assoc($query))
>>>>> var_dump ($row);
>>>>>
>>>>>$query =3D mysql_query("DELETE FROM table WHERE id=3D{$var}") or
>>>>>die("delete error: " . mysql_error());
>>>>>
>>>>>On Wed, Sep 3, 2008 at 12:33 PM, David DURIEUX
>>>>> wrote:
>>>>>> Bonjour,
>>>>>>
>>>>>> I have :
>>>>>>
>>>>>> NULL
>>>>>>
>>>>>>
>>>>>>
>>>>>> Cordialement,
>>>>>>
>>>>>> David DURIEUX
>>>>>> Tel : 04.74.04.81.34
>>>>>> Port : 06.34.99.45.18
>>>>>> Mail : d.durieux@siprossii.com
>>>>>> Site Web : http://www.siprossii.com/
>>>>>>
>>>>>> SIPROSSII
>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>
>>>>>>
>>>>>>
>>>>>> Le Wed, 3 Sep 2008 12:29:44 +0200
>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>
>>>>>>>Which means you do get results and your select works.
>>>>>>>
>>>>>>>Now try:
>>>>>>>
>>>>>>>$var=3D107;
>>>>>>>$query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};") or
>>>>>>>die(mysql_error());
>>>>>>>
>>>>>>>if ($row =3D mysql_fetch_assoc($query))
>>>>>>> var_dump ($data);
>>>>>>>
>>>>>>>$query =3D mysql_query("DELETE FROM table WHERE id=3D{$var}") or
>>>>>>>die(mysql_error());
>>>>>>>
>>>>>>>On Wed, Sep 3, 2008 at 12:25 PM, David DURIEUX
>>>>>>> wrote:
>>>>>>>> Bonjour,
>>>>>>>>
>>>>>>>> string(0) "" int(1)
>>>>>>>> string(0) "" int(1)
>>>>>>>> string(0) "" int(1)
>>>>>>>>
>>>>>>>> Cordialement,
>>>>>>>>
>>>>>>>> David DURIEUX
>>>>>>>> Tel : 04.74.04.81.34
>>>>>>>> Port : 06.34.99.45.18
>>>>>>>> Mail : d.durieux@siprossii.com
>>>>>>>> Site Web : http://www.siprossii.com/
>>>>>>>>
>>>>>>>> SIPROSSII
>>>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Le Wed, 03 Sep 2008 05:23:19 -0500
>>>>>>>> Micah Gersten a =E9crit:
>>>>>>>>
>>>>>>>>>You have to pass mysql_num_rows a $result variable from your
>>>>>>>>>query.
>>>>>>>>>
>>>>>>>>>Thank you,
>>>>>>>>>Micah Gersten
>>>>>>>>>onShore Networks
>>>>>>>>>Internal Developer
>>>>>>>>>http://www.onshore.com
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>David DURIEUX wrote:
>>>>>>>>>> Bonjour,
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Cordialement,
>>>>>>>>>>
>>>>>>>>>> David DURIEUX
>>>>>>>>>> Tel : 04.74.04.81.34
>>>>>>>>>> Port : 06.34.99.45.18
>>>>>>>>>> Mail : d.durieux@siprossii.com
>>>>>>>>>> Site Web : http://www.siprossii.com/
>>>>>>>>>>
>>>>>>>>>> SIPROSSII
>>>>>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>>>>>
>>>>>>>>>> ID is INT. It's ok before.
>>>>>>>>>>
>>>>>>>>>> I have errors :
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Warning: Wrong parameter count for mysql_num_rows()
>>>>>>>>>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma i=
nes.php
>>>>>>>>>> on line 7 string(0) "" NULL
>>>>>>>>>>
>>>>>>>>>> Warning: Wrong parameter count for mysql_num_rows()
>>>>>>>>>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma i=
nes.php
>>>>>>>>>> on line 12 string(0) "" NULL
>>>>>>>>>>
>>>>>>>>>> Warning: Wrong parameter count for mysql_num_rows()
>>>>>>>>>> in /usr/home/sites/CL000001/Web_data/hebergement/pages/sousdoma i=
nes.php
>>>>>>>>>> on line 16 string(0) "" NULL
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>> Le Wed, 3 Sep 2008 12:11:00 +0200
>>>>>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>>> In fact the first return 0 results
>>>>>>>>>>>>
>>>>>>>>>>> So the problem is in your select, and if your select works
>>>>>>>>>>> when you manually insert the value for id (iow, without
>>>>>>>>>>> using $var), the problem has something to do with $var.
>>>>>>>>>>>
>>>>>>>>>>> Is the data type of the ID column INT? Try the following and
>>>>>>>>>>> let us know the output:
>>>>>>>>>>>
>>>>>>>>>>> $var=3D107;
>>>>>>>>>>> $query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};")
>>>>>>>>>>> or die(mysql_error()); // make sure to use double quotes
>>>>>>>>>>> var_dump(mysql_error(), mysql_num_rows());
>>>>>>>>>>>
>>>>>>>>>>> $var=3Dmysql_real_escape_string("107");
>>>>>>>>>>> $query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};")
>>>>>>>>>>> or die(mysql_error()); // make sure to use double quotes
>>>>>>>>>>> var_dump(mysql_error(), mysql_num_rows());
>>>>>>>>>>>
>>>>>>>>>>> $query =3D mysql_query("SELECT * FROM table WHERE id=3D107;") or
>>>>>>>>>>> die(mysql_error()); // make sure to use double quotes
>>>>>>>>>>> var_dump(mysql_error(), mysql_num_rows());
>>>>>>>>>>>
>>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>
>>>>
>>
>>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

RGlkIHlvdSBjaGFuZ2UgJHZhcj0xMDg7IGludG8KJHZhcj1teXNxbF9yZWFs X2VzY2FwZV9zdHJp
bmcoJF9HRVRbJ2RlbGV0ZWlkJ10pPyA6CgppZiAoaXNzZXQoJF9HRVRbJ2Rl bGV0ZWlkJ10pKXsK
ICAgICAgICAkdmFyPW15c3FsX3JlYWxfZXNjYXBlX3N0cmluZygkX0dFVFsn ZGVsZXRlaWQnXSk7
CiAgICAgICAgJHF1ZXJ5ID0gbXlzcWxfcXVlcnkoIlNFTEVDVCAqIEZST00g dGFibGUgV0hFUkUg
aWQ9eyR2YXJ9OyIpIG9yCiAgICAgICAgZGllKCJzZWxlY3QgZXJyb3I6ICIg LiBteXNxbF9lcnJv
cigpKTsKCiAgICAgICAgaWYgKCRyb3cgPSBteXNxbF9mZXRjaF9hc3NvYygk cXVlcnkpKSB7CiAg
ICAgICAgICAgIHZhcl9kdW1wICgkcm93KTsKICAgICAgICAgICAgJHF1ZXJ5 ID0gbXlzcWxfcXVl
cnkoIkRFTEVURSBGUk9NIHRhYmxlIFdIRVJFIGlkPXskdmFyfSIpIG9yCiAg ICAgICAgICAgIGRp
ZSgiZGVsZXRlIGVycm9yOiAiIC4gbXlzcWxfZXJyb3IoKSk7CiAgICAgICAg fQp9CgpPbiBXZWQs
IFNlcCAzLCAyMDA4IGF0IDEyOjU3IFBNLCBEYXZpZCBEVVJJRVVYIDxkLmR1 cmlldXhAc2lwcm9z
c2lpLmNvbT4gd3JvdGU6Cj4gQm9uam91ciwKPgo+IGFycmF5KDIpIHsgWyJt b2R1bGUiXT0+ICBz
dHJpbmcoMTIpICJzb3VzZG9tYWluZXMiIFsiZGVsZXRlaWQiXT0+Cj4gc3Ry aW5nKDMpICIxMzMi
IH0KPgo+Cj4gTm90ZSA6IFRoZSBJRCBpcyBnb29kIGRlbGV0ZWQgYnV0IG5v IHNlbGVjdCByZXR1
cm4KPgo+IENvcmRpYWxlbWVudCwKPgo+IERhdmlkIERVUklFVVgKPiBUZWwg OiAwNC43NC4wNC44
MS4zNAo+IFBvcnQgOiAwNi4zNC45OS40NS4xOAo+IE1haWwgOiBkLmR1cmll dXhAc2lwcm9zc2lp
LmNvbQo+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXByb3NzaWkuY29tLwo+ Cj4gU0lQUk9TU0lJ
Cj4gODQ3IHJvdXRlIGRlIEZyYW5zIChDcsOpYWNpdMOpKQo+IDY5NDAwIFZp bGxlZnJhbmNoZSBz
dXIgU2HDtG5lCj4KPgo+Cj4gTGUgV2VkLCAzIFNlcCAyMDA4IDEyOjU0OjE5 ICswMjAwCj4gIkV2
ZXJ0IExhbW1lcnRzIiA8ZXZlcnQubGFtbWVydHNAZ21haWwuY29tPiBhIMOp Y3JpdDoKPgo+Pldo
YXQgZG9lcyB2YXJfZHVtcCgkX0dFVCkgc2F5Pwo+Pgo+Pk9uIFdlZCwgU2Vw IDMsIDIwMDggYXQg
MTI6NDggUE0sIERhdmlkIERVUklFVVgKPj48ZC5kdXJpZXV4QHNpcHJvc3Np aS5jb20+IHdyb3Rl
Ogo+Pj4gQm9uam91ciwKPj4+Cj4+PiBUaGUgcXVlcnkgd29ya3MKPj4+Cj4+ PiBCdXQgd2hlbiBJ
IHdyb3RlIHRoaXMgOgo+Pj4KPj4+Cj4+PiBpZiAoaXNzZXQoJF9HRVRbJ2Rl bGV0ZWlkJ10pKXsK
Pj4+Cj4+PiAgICAgICAgJHZhcj0xMDg7Cj4+PiAgICAgICAgJHF1ZXJ5ID0g bXlzcWxfcXVlcnko
IlNFTEVDVCAqIEZST00gdGFibGUgV0hFUkUgaWQ9eyR2YXJ9OyIpCj4+PiBv ciBkaWUoInNlbGVj
dCBlcnJvcjogIiAuIG15c3FsX2Vycm9yKCkpOwo+Pj4KPj4+ICAgICAgICBp ZiAoJHJvdyA9IG15
c3FsX2ZldGNoX2Fzc29jKCRxdWVyeSkpCj4+PiAgICAgICAgdmFyX2R1bXAg KCRyb3cpOwo+Pj4K
Pj4+ICAgICAgICAkcXVlcnkgPSBteXNxbF9xdWVyeSgiREVMRVRFIEZST00g dGFibGUgV0hFUkUg
aWQ9eyR2YXJ9Iikgb3IKPj4+ICAgICAgICBkaWUoImRlbGV0ZSBlcnJvcjog IiAuIG15c3FsX2Vy
cm9yKCkpOwo+Pj4KPj4+Cj4+PiB9Cj4+Pgo+Pj4KPj4+IEl0IG5vdCB3b3Jr cyBhbmQgbm8gcmV0
dXJuIGFuZCBubyBlcnJvciAuCj4+Pgo+Pj4gSWYgSSBwbGFjZSB0aGUgcXVl cnkgeW91IGhhdmUg
c2VudCBtZSB3aXRob3V0IHRoZSBpZiBpdCB3b3JrcyBidXQgSQo+Pj4gbXVz dCBoYXZlIGEgaWYg
Zm9yIGRlbGV0ZSB0aGUgSUQKPj4+Cj4+PiBJdCBpcyB2ZXJ5IHN0cmFuZ2UK Pj4+Cj4+PiBDb3Jk
aWFsZW1lbnQsCj4+Pgo+Pj4gRGF2aWQgRFVSSUVVWAo+Pj4gVGVsIDogMDQu NzQuMDQuODEuMzQK
Pj4+IFBvcnQgOiAwNi4zNC45OS40NS4xOAo+Pj4gTWFpbCA6IGQuZHVyaWV1 eEBzaXByb3NzaWku
Y29tCj4+PiBTaXRlIFdlYiA6IGh0dHA6Ly93d3cuc2lwcm9zc2lpLmNvbS8K Pj4+Cj4+PiBTSVBS
T1NTSUkKPj4+IDg0NyByb3V0ZSBkZSBGcmFucyAoQ3LDqWFjaXTDqSkKPj4+ IDY5NDAwIFZpbGxl
ZnJhbmNoZSBzdXIgU2HDtG5lCj4+Pgo+Pj4KPj4+Cj4+PiBMZSBXZWQsIDMg U2VwIDIwMDggMTI6
Mzk6NDUgKzAyMDAKPj4+ICJFdmVydCBMYW1tZXJ0cyIgPGV2ZXJ0LmxhbW1l cnRzQGdtYWlsLmNv
bT4gYSDDqWNyaXQ6Cj4+Pgo+Pj4+Rml4ZWQgdGhlbj8KPj4+Pgo+Pj4+T24g V2VkLCBTZXAgMywg
MjAwOCBhdCAxMjozOSBQTSwgRGF2aWQgRFVSSUVVWAo+Pj4+PGQuZHVyaWV1 eEBzaXByb3NzaWku
Y29tPiB3cm90ZToKPj4+Pj4gQm9uam91ciwKPj4+Pj4KPj4+Pj4gWWVzIEkg aGF2ZSB0aGUgdmFs
dWVzCj4+Pj4+Cj4+Pj4+IGFycmF5KDUpIHsgWyJpZCJdPT4gIHN0cmluZygz KSAiMTIxIiBbImRv
bWFpbmUiXT0+ICBzdHJpbmcoMSkKPj4+Pj4gIjEiIFsic291c19kb21haW5l Il09PiAgc3RyaW5n
KDgpICJhYWFhYWFhYSIgWyJyZXBlcnRvaXJlIl09Pgo+Pj4+PiBzdHJpbmco MCkgIiIgWyJyZWRp
cmVjdGlvbiJdPT4gIHN0cmluZygxKSAiMCIgfQo+Pj4+Pgo+Pj4+Pgo+Pj4+ PiBDb3JkaWFsZW1l
bnQsCj4+Pj4+Cj4+Pj4+IERhdmlkIERVUklFVVgKPj4+Pj4gVGVsIDogMDQu NzQuMDQuODEuMzQK
Pj4+Pj4gUG9ydCA6IDA2LjM0Ljk5LjQ1LjE4Cj4+Pj4+IE1haWwgOiBkLmR1 cmlldXhAc2lwcm9z
c2lpLmNvbQo+Pj4+PiBTaXRlIFdlYiA6IGh0dHA6Ly93d3cuc2lwcm9zc2lp LmNvbS8KPj4+Pj4K
Pj4+Pj4gU0lQUk9TU0lJCj4+Pj4+IDg0NyByb3V0ZSBkZSBGcmFucyAoQ3LD qWFjaXTDqSkKPj4+
Pj4gNjk0MDAgVmlsbGVmcmFuY2hlIHN1ciBTYcO0bmUKPj4+Pj4KPj4+Pj4K Pj4+Pj4KPj4+Pj4g
TGUgV2VkLCAzIFNlcCAyMDA4IDEyOjM2OjQzICswMjAwCj4+Pj4+ICJFdmVy dCBMYW1tZXJ0cyIg
PGV2ZXJ0LmxhbW1lcnRzQGdtYWlsLmNvbT4gYSDDqWNyaXQ6Cj4+Pj4+Cj4+ Pj4+Pkkga2VlcCBv
biBtYWtpbmcgbWlzdGFrZXMuICRkYXRhIHNob3VsZCBiZSAkcm93IGluIHRo ZSB2YXJfZHVtcCAt
Cj4+Pj4+PmJ1dCByaWdodCBub3cgeW91ciBERUxFVEUgaGFzIGFscmVhZHkg ZGVsZXRlZCBpZCAx
NyAodGhlIGZhY3QgdGhhdAo+Pj4+Pj5pdCBwcmludHMgTlVMTCBtZWFucyB0 aGUgaWYgY29uZGl0
aW9uIHdhcyBzYXRpc2ZpZWQpLiBTbyByZXBsYWNlCj4+Pj4+PnRoZSBiZWxv dyBjb2RlIHdpdGgg
YSBkaWZmZXJlbnQgJHZhciB2YWx1ZToKPj4+Pj4+Cj4+Pj4+PiR2YXI9MTA3 Owo+Pj4+Pj4kcXVl
cnkgPSBteXNxbF9xdWVyeSgiU0VMRUNUICogRlJPTSB0YWJsZSBXSEVSRSBp ZD17JHZhcn07Iikg
b3IKPj4+Pj4+ZGllKCJzZWxlY3QgZXJyb3I6ICIgLiBteXNxbF9lcnJvcigp KTsKPj4+Pj4+Cj4+
Pj4+PmlmICgkcm93ID0gbXlzcWxfZmV0Y2hfYXNzb2MoJHF1ZXJ5KSkKPj4+ Pj4+IHZhcl9kdW1w
ICgkcm93KTsKPj4+Pj4+Cj4+Pj4+PiRxdWVyeSA9IG15c3FsX3F1ZXJ5KCJE RUxFVEUgRlJPTSB0
YWJsZSBXSEVSRSBpZD17JHZhcn0iKSBvcgo+Pj4+Pj5kaWUoImRlbGV0ZSBl cnJvcjogIiAuIG15
c3FsX2Vycm9yKCkpOwo+Pj4+Pj4KPj4+Pj4+T24gV2VkLCBTZXAgMywgMjAw OCBhdCAxMjozMyBQ
TSwgRGF2aWQgRFVSSUVVWAo+Pj4+Pj48ZC5kdXJpZXV4QHNpcHJvc3NpaS5j b20+IHdyb3RlOgo+
Pj4+Pj4+IEJvbmpvdXIsCj4+Pj4+Pj4KPj4+Pj4+PiBJIGhhdmUgOgo+Pj4+ Pj4+Cj4+Pj4+Pj4g
TlVMTAo+Pj4+Pj4+Cj4+Pj4+Pj4KPj4+Pj4+Pgo+Pj4+Pj4+IENvcmRpYWxl bWVudCwKPj4+Pj4+
Pgo+Pj4+Pj4+IERhdmlkIERVUklFVVgKPj4+Pj4+PiBUZWwgOiAwNC43NC4w NC44MS4zNAo+Pj4+
Pj4+IFBvcnQgOiAwNi4zNC45OS40NS4xOAo+Pj4+Pj4+IE1haWwgOiBkLmR1 cmlldXhAc2lwcm9z
c2lpLmNvbQo+Pj4+Pj4+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXByb3Nz aWkuY29tLwo+Pj4+
Pj4+Cj4+Pj4+Pj4gU0lQUk9TU0lJCj4+Pj4+Pj4gODQ3IHJvdXRlIGRlIEZy YW5zIChDcsOpYWNp
dMOpKQo+Pj4+Pj4+IDY5NDAwIFZpbGxlZnJhbmNoZSBzdXIgU2HDtG5lCj4+ Pj4+Pj4KPj4+Pj4+
Pgo+Pj4+Pj4+Cj4+Pj4+Pj4gTGUgV2VkLCAzIFNlcCAyMDA4IDEyOjI5OjQ0 ICswMjAwCj4+Pj4+
Pj4gIkV2ZXJ0IExhbW1lcnRzIiA8ZXZlcnQubGFtbWVydHNAZ21haWwuY29t PiBhIMOpY3JpdDoK
Pj4+Pj4+Pgo+Pj4+Pj4+PldoaWNoIG1lYW5zIHlvdSBkbyBnZXQgcmVzdWx0 cyBhbmQgeW91ciBz
ZWxlY3Qgd29ya3MuCj4+Pj4+Pj4+Cj4+Pj4+Pj4+Tm93IHRyeToKPj4+Pj4+ Pj4KPj4+Pj4+Pj4k
dmFyPTEwNzsKPj4+Pj4+Pj4kcXVlcnkgPSBteXNxbF9xdWVyeSgiU0VMRUNU ICogRlJPTSB0YWJs
ZSBXSEVSRSBpZD17JHZhcn07Iikgb3IKPj4+Pj4+Pj5kaWUobXlzcWxfZXJy b3IoKSk7Cj4+Pj4+
Pj4+Cj4+Pj4+Pj4+aWYgKCRyb3cgPSBteXNxbF9mZXRjaF9hc3NvYygkcXVl cnkpKQo+Pj4+Pj4+
PiB2YXJfZHVtcCAoJGRhdGEpOwo+Pj4+Pj4+Pgo+Pj4+Pj4+PiRxdWVyeSA9 IG15c3FsX3F1ZXJ5
KCJERUxFVEUgRlJPTSB0YWJsZSBXSEVSRSBpZD17JHZhcn0iKSBvcgo+Pj4+ Pj4+PmRpZShteXNx
bF9lcnJvcigpKTsKPj4+Pj4+Pj4KPj4+Pj4+Pj5PbiBXZWQsIFNlcCAzLCAy MDA4IGF0IDEyOjI1
IFBNLCBEYXZpZCBEVVJJRVVYCj4+Pj4+Pj4+PGQuZHVyaWV1eEBzaXByb3Nz aWkuY29tPiB3cm90
ZToKPj4+Pj4+Pj4+IEJvbmpvdXIsCj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4gc3Ry aW5nKDApICIiIGlu
dCgxKQo+Pj4+Pj4+Pj4gc3RyaW5nKDApICIiIGludCgxKQo+Pj4+Pj4+Pj4g c3RyaW5nKDApICIi
IGludCgxKQo+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+IENvcmRpYWxlbWVudCwKPj4+ Pj4+Pj4+Cj4+Pj4+
Pj4+PiBEYXZpZCBEVVJJRVVYCj4+Pj4+Pj4+PiBUZWwgOiAwNC43NC4wNC44 MS4zNAo+Pj4+Pj4+
Pj4gUG9ydCA6IDA2LjM0Ljk5LjQ1LjE4Cj4+Pj4+Pj4+PiBNYWlsIDogZC5k dXJpZXV4QHNpcHJv
c3NpaS5jb20KPj4+Pj4+Pj4+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXBy b3NzaWkuY29tLwo+
Pj4+Pj4+Pj4KPj4+Pj4+Pj4+IFNJUFJPU1NJSQo+Pj4+Pj4+Pj4gODQ3IHJv dXRlIGRlIEZyYW5z
IChDcsOpYWNpdMOpKQo+Pj4+Pj4+Pj4gNjk0MDAgVmlsbGVmcmFuY2hlIHN1 ciBTYcO0bmUKPj4+
Pj4+Pj4+Cj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+IExlIFdlZCwg MDMgU2VwIDIwMDgg
MDU6MjM6MTkgLTA1MDAKPj4+Pj4+Pj4+IE1pY2FoIEdlcnN0ZW4gPG1pY2Fo QG9uc2hvcmUuY29t
PiBhIMOpY3JpdDoKPj4+Pj4+Pj4+Cj4+Pj4+Pj4+Pj5Zb3UgaGF2ZSB0byBw YXNzIG15c3FsX251
bV9yb3dzIGEgJHJlc3VsdCB2YXJpYWJsZSBmcm9tIHlvdXIKPj4+Pj4+Pj4+ PnF1ZXJ5Lgo+Pj4+
Pj4+Pj4+Cj4+Pj4+Pj4+Pj5UaGFuayB5b3UsCj4+Pj4+Pj4+Pj5NaWNhaCBH ZXJzdGVuCj4+Pj4+
Pj4+Pj5vblNob3JlIE5ldHdvcmtzCj4+Pj4+Pj4+Pj5JbnRlcm5hbCBEZXZl bG9wZXIKPj4+Pj4+
Pj4+Pmh0dHA6Ly93d3cub25zaG9yZS5jb20KPj4+Pj4+Pj4+Pgo+Pj4+Pj4+ Pj4+Cj4+Pj4+Pj4+
Pj4KPj4+Pj4+Pj4+PkRhdmlkIERVUklFVVggd3JvdGU6Cj4+Pj4+Pj4+Pj4+ IEJvbmpvdXIsCj4+
Pj4+Pj4+Pj4+Cj4+Pj4+Pj4+Pj4+Cj4+Pj4+Pj4+Pj4+Cj4+Pj4+Pj4+Pj4+ IENvcmRpYWxlbWVu
dCwKPj4+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+Pj4gRGF2aWQgRFVSSUVVWAo+Pj4+ Pj4+Pj4+PiBUZWwg
OiAwNC43NC4wNC44MS4zNAo+Pj4+Pj4+Pj4+PiBQb3J0IDogMDYuMzQuOTku NDUuMTgKPj4+Pj4+
Pj4+Pj4gTWFpbCA6IGQuZHVyaWV1eEBzaXByb3NzaWkuY29tCj4+Pj4+Pj4+ Pj4+IFNpdGUgV2Vi
IDogaHR0cDovL3d3dy5zaXByb3NzaWkuY29tLwo+Pj4+Pj4+Pj4+Pgo+Pj4+ Pj4+Pj4+PiBTSVBS
T1NTSUkKPj4+Pj4+Pj4+Pj4gODQ3IHJvdXRlIGRlIEZyYW5zIChDcsOpYWNp dMOpKQo+Pj4+Pj4+
Pj4+PiA2OTQwMCBWaWxsZWZyYW5jaGUgc3VyIFNhw7RuZQo+Pj4+Pj4+Pj4+ Pgo+Pj4+Pj4+Pj4+
PiBJRCBpcyBJTlQuIEl0J3Mgb2sgYmVmb3JlLgo+Pj4+Pj4+Pj4+Pgo+Pj4+ Pj4+Pj4+PiBJIGhh
dmUgZXJyb3JzIDoKPj4+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+ Pj4gV2FybmluZzog
V3JvbmcgcGFyYW1ldGVyIGNvdW50IGZvciBteXNxbF9udW1fcm93cygpCj4+ Pj4+Pj4+Pj4+IGlu
IC91c3IvaG9tZS9zaXRlcy9DTDAwMDAwMS9XZWJfZGF0YS9oZWJlcmdlbWVu dC9wYWdlcy9zb3Vz
ZG9tYWluZXMucGhwCj4+Pj4+Pj4+Pj4+IG9uIGxpbmUgNyBzdHJpbmcoMCkg IiIgTlVMTAo+Pj4+
Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+PiBXYXJuaW5nOiBXcm9uZyBwYXJhbWV0ZXIg Y291bnQgZm9yIG15
c3FsX251bV9yb3dzKCkKPj4+Pj4+Pj4+Pj4gaW4gL3Vzci9ob21lL3NpdGVz L0NMMDAwMDAxL1dl
Yl9kYXRhL2hlYmVyZ2VtZW50L3BhZ2VzL3NvdXNkb21haW5lcy5waHAKPj4+ Pj4+Pj4+Pj4gb24g
bGluZSAxMiBzdHJpbmcoMCkgIiIgTlVMTAo+Pj4+Pj4+Pj4+Pgo+Pj4+Pj4+ Pj4+PiBXYXJuaW5n
OiBXcm9uZyBwYXJhbWV0ZXIgY291bnQgZm9yIG15c3FsX251bV9yb3dzKCkK Pj4+Pj4+Pj4+Pj4g
aW4gL3Vzci9ob21lL3NpdGVzL0NMMDAwMDAxL1dlYl9kYXRhL2hlYmVyZ2Vt ZW50L3BhZ2VzL3Nv
dXNkb21haW5lcy5waHAKPj4+Pj4+Pj4+Pj4gb24gbGluZSAxNiBzdHJpbmco MCkgIiIgTlVMTAo+
Pj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+ PiBMZSBXZWQsIDMg
U2VwIDIwMDggMTI6MTE6MDAgKzAyMDAKPj4+Pj4+Pj4+Pj4gIkV2ZXJ0IExh bW1lcnRzIiA8ZXZl
cnQubGFtbWVydHNAZ21haWwuY29tPiBhIMOpY3JpdDoKPj4+Pj4+Pj4+Pj4K Pj4+Pj4+Pj4+Pj4K
Pj4+Pj4+Pj4+Pj4+PiBJbiBmYWN0IHRoZSBmaXJzdCByZXR1cm4gMCByZXN1 bHRzCj4+Pj4+Pj4+
Pj4+Pj4KPj4+Pj4+Pj4+Pj4+IFNvIHRoZSBwcm9ibGVtIGlzIGluIHlvdXIg c2VsZWN0LCBhbmQg
aWYgeW91ciBzZWxlY3Qgd29ya3MKPj4+Pj4+Pj4+Pj4+IHdoZW4geW91IG1h bnVhbGx5IGluc2Vy
dCB0aGUgdmFsdWUgZm9yIGlkIChpb3csIHdpdGhvdXQKPj4+Pj4+Pj4+Pj4+ IHVzaW5nICR2YXIp
LCB0aGUgcHJvYmxlbSBoYXMgc29tZXRoaW5nIHRvIGRvIHdpdGggJHZhci4K Pj4+Pj4+Pj4+Pj4+
Cj4+Pj4+Pj4+Pj4+PiBJcyB0aGUgZGF0YSB0eXBlIG9mIHRoZSBJRCBjb2x1 bW4gSU5UPyBUcnkg
dGhlIGZvbGxvd2luZyBhbmQKPj4+Pj4+Pj4+Pj4+IGxldCB1cyBrbm93IHRo ZSBvdXRwdXQ6Cj4+
Pj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+Pj4gJHZhcj0xMDc7Cj4+Pj4+Pj4+Pj4+ PiAkcXVlcnkgPSBt
eXNxbF9xdWVyeSgiU0VMRUNUICogRlJPTSB0YWJsZSBXSEVSRSBpZD17JHZh cn07IikKPj4+Pj4+
Pj4+Pj4+IG9yIGRpZShteXNxbF9lcnJvcigpKTsgLy8gbWFrZSBzdXJlIHRv IHVzZSBkb3VibGUg
cXVvdGVzCj4+Pj4+Pj4+Pj4+PiB2YXJfZHVtcChteXNxbF9lcnJvcigpLCBt eXNxbF9udW1fcm93
cygpKTsKPj4+Pj4+Pj4+Pj4+Cj4+Pj4+Pj4+Pj4+PiAkdmFyPW15c3FsX3Jl YWxfZXNjYXBlX3N0
cmluZygiMTA3Iik7Cj4+Pj4+Pj4+Pj4+PiAkcXVlcnkgPSBteXNxbF9xdWVy eSgiU0VMRUNUICog
RlJPTSB0YWJsZSBXSEVSRSBpZD17JHZhcn07IikKPj4+Pj4+Pj4+Pj4+IG9y IGRpZShteXNxbF9l
cnJvcigpKTsgLy8gbWFrZSBzdXJlIHRvIHVzZSBkb3VibGUgcXVvdGVzCj4+ Pj4+Pj4+Pj4+PiB2
YXJfZHVtcChteXNxbF9lcnJvcigpLCBteXNxbF9udW1fcm93cygpKTsKPj4+ Pj4+Pj4+Pj4+Cj4+
Pj4+Pj4+Pj4+PiAkcXVlcnkgPSBteXNxbF9xdWVyeSgiU0VMRUNUICogRlJP TSB0YWJsZSBXSEVS
RSBpZD0xMDc7Iikgb3IKPj4+Pj4+Pj4+Pj4+IGRpZShteXNxbF9lcnJvcigp KTsgLy8gbWFrZSBz
dXJlIHRvIHVzZSBkb3VibGUgcXVvdGVzCj4+Pj4+Pj4+Pj4+PiB2YXJfZHVt cChteXNxbF9lcnJv
cigpLCBteXNxbF9udW1fcm93cygpKTsKPj4+Pj4+Pj4+Pj4+Cj4+Pj4+Pj4+ Pj4+Pgo+Pj4+Pj4+
Pj4+Pgo+Pj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+Cj4+Pj4+ Pj4+Pgo+Pj4+Pj4+
Pj4KPj4+Pj4+Pj4+IC0tCj4+Pj4+Pj4+PiBQSFAgRGF0YWJhc2UgTWFpbGlu ZyBMaXN0IChodHRw
Oi8vd3d3LnBocC5uZXQvKQo+Pj4+Pj4+Pj4gVG8gdW5zdWJzY3JpYmUsIHZp c2l0OiBodHRwOi8v
d3d3LnBocC5uZXQvdW5zdWIucGhwCj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4KPj4+ Pj4+Pgo+Pj4+Pj4+
Cj4+Pj4+Cj4+Pj4+Cj4+Pgo+Pj4KPgo+Cj4gLS0KPiBQSFAgRGF0YWJhc2Ug TWFpbGluZyBMaXN0
IChodHRwOi8vd3d3LnBocC5uZXQvKQo+IFRvIHVuc3Vic2NyaWJlLCB2aXNp dDogaHR0cDovL3d3
dy5waHAubmV0L3Vuc3ViLnBocAo+Cj4K

Re: Probleme with MySQL queries

> I have :
>
> array(2) { ["module"]=> string(12) "sousdomaines" ["deleteid"]=>
> string(3) "134" }
>
> But the ID is not deleted in mysql.

That seems to be your var_dump($_GET), which means that either if
(isset($_GET['deleteid'])) evaluates to FALSE or your SELECT does not
return results. Let's check:

if (strlen($_GET["deleteid"])) {
var_dump($_GET["deleteid"]);
$var = mysql_real_escape_string($_GET["deleteid"]);
$query = mysql_query("SELECT * FROM table WHERE id={$var};")
or die("select error: " . mysql_error());
var_dump(mysql_num_rows($query));
if ($row = mysql_fetch_assoc($query)) {
var_dump ($row);
mysql_query("DELETE FROM table WHERE id={$row['id']}") or
die("delete error: " . mysql_error());
}
}

> In must be away for 2 or 3 hours, I return after to continue this.
French lunch I'm guessing :-) I'm jealous! You guys know how to do
that, with your perfect cheese and sausage! I'll be away myself from
half past 2.

Try to keep your replies on the list - it's useful for others.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

I Have now :=20


string(3) "134" int(0)



Lunch... NOT, I haven't the time today :p but cheese and sausage is
good :)

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 13:19:52 +0200
"Evert Lammerts" a =E9crit:

>> I have :
>>
>> array(2) { ["module"]=3D> string(12) "sousdomaines" ["deleteid"]=3D>
>> string(3) "134" }
>>
>> But the ID is not deleted in mysql.
>
>That seems to be your var_dump($_GET), which means that either if
>(isset($_GET['deleteid'])) evaluates to FALSE or your SELECT does not
>return results. Let's check:
>
>if (strlen($_GET["deleteid"])) {
> var_dump($_GET["deleteid"]);
> $var =3D mysql_real_escape_string($_GET["deleteid"]);
> $query =3D mysql_query("SELECT * FROM table WHERE id=3D{$var};")
>or die("select error: " . mysql_error());
> var_dump(mysql_num_rows($query));
> if ($row =3D mysql_fetch_assoc($query)) {
> var_dump ($row);
> mysql_query("DELETE FROM table WHERE id=3D{$row['id']}") or
>die("delete error: " . mysql_error());
> }
>}
>
>> In must be away for 2 or 3 hours, I return after to continue this.
>French lunch I'm guessing :-) I'm jealous! You guys know how to do
>that, with your perfect cheese and sausage! I'll be away myself from
>half past 2.
>
>Try to keep your replies on the list - it's useful for others.
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

> string(3) "134" int(0)

This means you're trying to delete the entry with id=3, and that it
cannot find that in the database. Are you sure it exists? We tried the
queries separately and the SELECT had no problem... SELECT * FROM
table WHERE id=3;

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

Are you sur it is 3 ? it is 134 no?

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 14:17:59 +0200
"Evert Lammerts" a =E9crit:

>> string(3) "134" int(0)
>
>This means you're trying to delete the entry with id=3D3, and that it
>cannot find that in the database. Are you sure it exists? We tried the
>queries separately and the SELECT had no problem... SELECT * FROM
>table WHERE id=3D3;
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

Humm with this query I have forgotten to tell you the ID is DELETED=20

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 14:17:59 +0200
"Evert Lammerts" a =E9crit:

>> string(3) "134" int(0)
>
>This means you're trying to delete the entry with id=3D3, and that it
>cannot find that in the database. Are you sure it exists? We tried the
>queries separately and the SELECT had no problem... SELECT * FROM
>table WHERE id=3D3;
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

> Humm with this query I have forgotten to tell you the ID is DELETED

You mean the record with id=134?

> Are you sur it is 3 ? it is 134 no?

You're right :-)

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

Yes record exist before the query and is deleted after

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 14:24:23 +0200
"Evert Lammerts" a =E9crit:

>> Humm with this query I have forgotten to tell you the ID is DELETED
>
>You mean the record with id=3D134?
>
>> Are you sur it is 3 ? it is 134 no?
>
>You're right :-)
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

When using mysql_query, the SQL string to be executed should not end
in a semicolon. Your initial post did not have a semicolon (but you
obviously edited it to make it generic). Perhaps this was the initial
problem? Subsequent posts had you terminating your queries with a
semicolon.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy wrote:
> When using mysql_query, the SQL string to be executed should not end
> in a semicolon.

Ending a query with a semicolon should not be a problem - the string
is parsed by the mysql server, which handles it fine.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts wrote:
> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy wrote:
>> When using mysql_query, the SQL string to be executed should not end
>> in a semicolon.
>
> Ending a query with a semicolon should not be a problem - the string
> is parsed by the mysql server, which handles it fine.

The manual does mention it, I'm a little too quick with my replies. I
personally never had a problem with it though. Plus, it seemed to work
some mails ago.

David, did I understand well that your problem is solved?

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

No, I must test a little more, I tell in few minutes....

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 20:05:22 +0200
"Evert Lammerts" a =E9crit:

>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
> wrote:
>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy wrote:
>>> When using mysql_query, the SQL string to be executed should not end
>>> in a semicolon.
>>
>> Ending a query with a semicolon should not be a problem - the string
>> is parsed by the mysql server, which handles it fine.
>
>The manual does mention it, I'm a little too quick with my replies. I
>personally never had a problem with it though. Plus, it seemed to work
>some mails ago.
>
>David, did I understand well that your problem is solved?
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

On Wed, Sep 3, 2008 at 1:05 PM, Evert Lammerts wrote:
> On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts wrote:
>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy wrote:
>>> When using mysql_query, the SQL string to be executed should not end
>>> in a semicolon.
>>
>> Ending a query with a semicolon should not be a problem - the string
>> is parsed by the mysql server, which handles it fine.
>
> The manual does mention it, I'm a little too quick with my replies. I
> personally never had a problem with it though. Plus, it seemed to work
> some mails ago.
>
> David, did I understand well that your problem is solved?
>

I have run into problems with it, and it is in the manual. But a test
case today did not display the problem on PHP version 4.1.2 and
version 5.1.6.

As I understood, this is/was a security feature so that SQL injection
could not terminate the real query, and add additional hacker queries
to the real query.

Now I'd like to know why it _IS_ executing _WITH_ a semicolon
_DESPITE_ what the manual says. Perhaps some
easily_forgettable_magic_flag.ini setting? Gotta love PHP for that.
Can we really rely completely on mysql_real_escape_string?

When David said the SELECT did not work, but the DELETE worked, I
thought for sure the semicolon was the problem. Also, that maybe he
just removed the SELECT part so he could move on.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

I have always the problem, select =3D 0 rows and it delete it like if
delete is before the select :/

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 20:05:22 +0200
"Evert Lammerts" a =E9crit:

>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
> wrote:
>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy wrote:
>>> When using mysql_query, the SQL string to be executed should not end
>>> in a semicolon.
>>
>> Ending a query with a semicolon should not be a problem - the string
>> is parsed by the mysql server, which handles it fine.
>
>The manual does mention it, I'm a little too quick with my replies. I
>personally never had a problem with it though. Plus, it seemed to work
>some mails ago.
>
>David, did I understand well that your problem is solved?
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

QXJlIHlvdSBzdGlsbCB1c2luZyB0aGUgY29kZSB3ZSB0YWxrZWQgYWJvdXQ/ CgppZiAoJHJvdyA9
IG15c3FsX2ZldGNoX2Fzc29jKCRxdWVyeSkpIHsKICAgICAgICAgICB2YXJf ZHVtcCAoJHJvdyk7
CiAgICAgICAgICAgbXlzcWxfcXVlcnkoIkRFTEVURSBGUk9NIHRhYmxlIFdI RVJFIGlkPXskcm93
WydpZCddfSIpIG9yCmRpZSgiZGVsZXRlIGVycm9yOiAiIC4gbXlzcWxfZXJy b3IoKSk7Cn0KCmlm
IHNvLCBhcHBhcmVudGx5IGl0IGRvZXMgZmV0Y2ggYSByb3cuIE90aGVyd2lz ZSwgY2FuIHlvdSBz
ZW5kIHRoZQpjb2RlIHlvdSdyZSB1c2luZz8KCk9uIFdlZCwgU2VwIDMsIDIw MDggYXQgODozNSBQ
TSwgRGF2aWQgRFVSSUVVWCA8ZC5kdXJpZXV4QHNpcHJvc3NpaS5jb20+IHdy b3RlOgo+IEJvbmpv
dXIsCj4KPiBJIGhhdmUgYWx3YXlzIHRoZSBwcm9ibGVtLCBzZWxlY3QgPSAw IHJvd3MgYW5kIGl0
IGRlbGV0ZSBpdCBsaWtlIGlmCj4gZGVsZXRlIGlzIGJlZm9yZSB0aGUgc2Vs ZWN0IDovCj4KPiBD
b3JkaWFsZW1lbnQsCj4KPiBEYXZpZCBEVVJJRVVYCj4gVGVsIDogMDQuNzQu MDQuODEuMzQKPiBQ
b3J0IDogMDYuMzQuOTkuNDUuMTgKPiBNYWlsIDogZC5kdXJpZXV4QHNpcHJv c3NpaS5jb20KPiBT
aXRlIFdlYiA6IGh0dHA6Ly93d3cuc2lwcm9zc2lpLmNvbS8KPgo+IFNJUFJP U1NJSQo+IDg0NyBy
b3V0ZSBkZSBGcmFucyAoQ3LDqWFjaXTDqSkKPiA2OTQwMCBWaWxsZWZyYW5j aGUgc3VyIFNhw7Ru
ZQo+Cj4KPgo+IExlIFdlZCwgMyBTZXAgMjAwOCAyMDowNToyMiArMDIwMAo+ ICJFdmVydCBMYW1t
ZXJ0cyIgPGV2ZXJ0LmxhbW1lcnRzQGdtYWlsLmNvbT4gYSDDqWNyaXQ6Cj4K Pj5PbiBXZWQsIFNl
cCAzLCAyMDA4IGF0IDc6NTggUE0sIEV2ZXJ0IExhbW1lcnRzCj4+PGV2ZXJ0 LmxhbW1lcnRzQGdt
YWlsLmNvbT4gd3JvdGU6Cj4+PiBPbiBXZWQsIFNlcCAzLCAyMDA4IGF0IDc6 NDEgUE0sIERlZSBB
eXkgPGRlZS5heXlAZ21haWwuY29tPiB3cm90ZToKPj4+PiBXaGVuIHVzaW5n IG15c3FsX3F1ZXJ5
LCB0aGUgU1FMIHN0cmluZyB0byBiZSBleGVjdXRlZCBzaG91bGQgbm90IGVu ZAo+Pj4+IGluIGEg
c2VtaWNvbG9uLgo+Pj4KPj4+IEVuZGluZyBhIHF1ZXJ5IHdpdGggYSBzZW1p Y29sb24gc2hvdWxk
IG5vdCBiZSBhIHByb2JsZW0gLSB0aGUgc3RyaW5nCj4+PiBpcyBwYXJzZWQg YnkgdGhlIG15c3Fs
IHNlcnZlciwgd2hpY2ggaGFuZGxlcyBpdCBmaW5lLgo+Pgo+PlRoZSBtYW51 YWwgZG9lcyBtZW50
aW9uIGl0LCBJJ20gYSBsaXR0bGUgdG9vIHF1aWNrIHdpdGggbXkgcmVwbGll cy4gSQo+PnBlcnNv
bmFsbHkgbmV2ZXIgaGFkIGEgcHJvYmxlbSB3aXRoIGl0IHRob3VnaC4gUGx1 cywgaXQgc2VlbWVk
IHRvIHdvcmsKPj5zb21lIG1haWxzIGFnby4KPj4KPj5EYXZpZCwgZGlkIEkg dW5kZXJzdGFuZCB3
ZWxsIHRoYXQgeW91ciBwcm9ibGVtIGlzIHNvbHZlZD8KPj4KPgo+Cj4gLS0K PiBQSFAgRGF0YWJh
c2UgTWFpbGluZyBMaXN0IChodHRwOi8vd3d3LnBocC5uZXQvKQo+IFRvIHVu c3Vic2NyaWJlLCB2
aXNpdDogaHR0cDovL3d3dy5waHAubmV0L3Vuc3ViLnBocAo+Cj4K

Re: Probleme with MySQL queries

> On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX wrote:
>> Bonjour,
>>
>> I have always the problem, select = 0 rows and it delete it like if
>> delete is before the select :/
>>
>> Cordialement,
>>
>> David DURIEUX

Your SELECT has a terminating semicolon. Your DELETE does not. Some
configurations of PHP do not execute from the mysql_query function if
the query is terminated with a semicolon.

What version of PHP are you using?
I wish I knew what flags to also ask about that affect the semicolon.
If in fact your problem is the semicolon.

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

Yes I'm using this query.... and no row select

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 20:43:25 +0200
"Evert Lammerts" a =E9crit:

>Are you still using the code we talked about?
>
>if ($row =3D mysql_fetch_assoc($query)) {
> var_dump ($row);
> mysql_query("DELETE FROM table WHERE id=3D{$row['id']}") or
>die("delete error: " . mysql_error());
>}
>
>if so, apparently it does fetch a row. Otherwise, can you send the
>code you're using?
>
>On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
> wrote:
>> Bonjour,
>>
>> I have always the problem, select =3D 0 rows and it delete it like if
>> delete is before the select :/
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>>
>> Le Wed, 3 Sep 2008 20:05:22 +0200
>> "Evert Lammerts" a =E9crit:
>>
>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>>> wrote:
>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy wrote:
>>>>> When using mysql_query, the SQL string to be executed should not
>>>>> end in a semicolon.
>>>>
>>>> Ending a query with a semicolon should not be a problem - the
>>>> string is parsed by the mysql server, which handles it fine.
>>>
>>>The manual does mention it, I'm a little too quick with my replies. I
>>>personally never had a problem with it though. Plus, it seemed to
>>>work some mails ago.
>>>
>>>David, did I understand well that your problem is solved?
>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

PHP 5.2.6 on FreeBSD 7.0 i386 associate with apache 2.0.63



Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 13:47:02 -0500
"Dee Ayy" a =E9crit:

>> On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
>> wrote:
>>> Bonjour,
>>>
>>> I have always the problem, select =3D 0 rows and it delete it like if
>>> delete is before the select :/
>>>
>>> Cordialement,
>>>
>>> David DURIEUX
>
>Your SELECT has a terminating semicolon. Your DELETE does not. Some
>configurations of PHP do not execute from the mysql_query function if
>the query is terminated with a semicolon.
>
>What version of PHP are you using?
>I wish I knew what flags to also ask about that affect the semicolon.
>If in fact your problem is the semicolon.
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

QnV0IHRoZSBERUxFVEUgaXMgZXhlY3V0ZWQ/IElmIGl0IGlzLCBhbmQgaXQn cyBpbiB0aGUgY29u
ZGl0aW9uLCBsaWtlCmluIHRoZSBhYm92ZSBjb2RlOgoKaWYgKCRyb3cgPSBt eXNxbF9mZXRjaF9h
c3NvYygkcXVlcnkpKSB7CiAgIC4uLi4gREVMRVRFIC4uLgp9Cgpzb21ldGhp bmcgYXBwYXJlbnRs
eSBpcyBmZXRjaGVkLi4uLgoKT24gV2VkLCBTZXAgMywgMjAwOCBhdCA4OjQ5 IFBNLCBEYXZpZCBE
VVJJRVVYIDxkLmR1cmlldXhAc2lwcm9zc2lpLmNvbT4gd3JvdGU6Cj4gQm9u am91ciwKPgo+IFll
cyBJJ20gdXNpbmcgdGhpcyBxdWVyeS4uLi4gYW5kIG5vIHJvdyBzZWxlY3QK Pgo+IENvcmRpYWxl
bWVudCwKPgo+IERhdmlkIERVUklFVVgKPiBUZWwgOiAwNC43NC4wNC44MS4z NAo+IFBvcnQgOiAw
Ni4zNC45OS40NS4xOAo+IE1haWwgOiBkLmR1cmlldXhAc2lwcm9zc2lpLmNv bQo+IFNpdGUgV2Vi
IDogaHR0cDovL3d3dy5zaXByb3NzaWkuY29tLwo+Cj4gU0lQUk9TU0lJCj4g ODQ3IHJvdXRlIGRl
IEZyYW5zIChDcsOpYWNpdMOpKQo+IDY5NDAwIFZpbGxlZnJhbmNoZSBzdXIg U2HDtG5lCj4KPgo+
Cj4gTGUgV2VkLCAzIFNlcCAyMDA4IDIwOjQzOjI1ICswMjAwCj4gIkV2ZXJ0 IExhbW1lcnRzIiA8
ZXZlcnQubGFtbWVydHNAZ21haWwuY29tPiBhIMOpY3JpdDoKPgo+PkFyZSB5 b3Ugc3RpbGwgdXNp
bmcgdGhlIGNvZGUgd2UgdGFsa2VkIGFib3V0Pwo+Pgo+PmlmICgkcm93ID0g bXlzcWxfZmV0Y2hf
YXNzb2MoJHF1ZXJ5KSkgewo+PiAgICAgICAgICAgdmFyX2R1bXAgKCRyb3cp Owo+PiAgICAgICAg
ICAgbXlzcWxfcXVlcnkoIkRFTEVURSBGUk9NIHRhYmxlIFdIRVJFIGlkPXsk cm93WydpZCddfSIp
IG9yCj4+ZGllKCJkZWxldGUgZXJyb3I6ICIgLiBteXNxbF9lcnJvcigpKTsK Pj59Cj4+Cj4+aWYg
c28sIGFwcGFyZW50bHkgaXQgZG9lcyBmZXRjaCBhIHJvdy4gT3RoZXJ3aXNl LCBjYW4geW91IHNl
bmQgdGhlCj4+Y29kZSB5b3UncmUgdXNpbmc/Cj4+Cj4+T24gV2VkLCBTZXAg MywgMjAwOCBhdCA4
OjM1IFBNLCBEYXZpZCBEVVJJRVVYCj4+PGQuZHVyaWV1eEBzaXByb3NzaWku Y29tPiB3cm90ZToK
Pj4+IEJvbmpvdXIsCj4+Pgo+Pj4gSSBoYXZlIGFsd2F5cyB0aGUgcHJvYmxl bSwgc2VsZWN0ID0g
MCByb3dzIGFuZCBpdCBkZWxldGUgaXQgbGlrZSBpZgo+Pj4gZGVsZXRlIGlz IGJlZm9yZSB0aGUg
c2VsZWN0IDovCj4+Pgo+Pj4gQ29yZGlhbGVtZW50LAo+Pj4KPj4+IERhdmlk IERVUklFVVgKPj4+
IFRlbCA6IDA0Ljc0LjA0LjgxLjM0Cj4+PiBQb3J0IDogMDYuMzQuOTkuNDUu MTgKPj4+IE1haWwg
OiBkLmR1cmlldXhAc2lwcm9zc2lpLmNvbQo+Pj4gU2l0ZSBXZWIgOiBodHRw Oi8vd3d3LnNpcHJv
c3NpaS5jb20vCj4+Pgo+Pj4gU0lQUk9TU0lJCj4+PiA4NDcgcm91dGUgZGUg RnJhbnMgKENyw6lh
Y2l0w6kpCj4+PiA2OTQwMCBWaWxsZWZyYW5jaGUgc3VyIFNhw7RuZQo+Pj4K Pj4+Cj4+Pgo+Pj4g
TGUgV2VkLCAzIFNlcCAyMDA4IDIwOjA1OjIyICswMjAwCj4+PiAiRXZlcnQg TGFtbWVydHMiIDxl
dmVydC5sYW1tZXJ0c0BnbWFpbC5jb20+IGEgw6ljcml0Ogo+Pj4KPj4+Pk9u IFdlZCwgU2VwIDMs
IDIwMDggYXQgNzo1OCBQTSwgRXZlcnQgTGFtbWVydHMKPj4+PjxldmVydC5s YW1tZXJ0c0BnbWFp
bC5jb20+IHdyb3RlOgo+Pj4+PiBPbiBXZWQsIFNlcCAzLCAyMDA4IGF0IDc6 NDEgUE0sIERlZSBB
eXkgPGRlZS5heXlAZ21haWwuY29tPiB3cm90ZToKPj4+Pj4+IFdoZW4gdXNp bmcgbXlzcWxfcXVl
cnksIHRoZSBTUUwgc3RyaW5nIHRvIGJlIGV4ZWN1dGVkIHNob3VsZCBub3QK Pj4+Pj4+IGVuZCBp
biBhIHNlbWljb2xvbi4KPj4+Pj4KPj4+Pj4gRW5kaW5nIGEgcXVlcnkgd2l0 aCBhIHNlbWljb2xv
biBzaG91bGQgbm90IGJlIGEgcHJvYmxlbSAtIHRoZQo+Pj4+PiBzdHJpbmcg aXMgcGFyc2VkIGJ5
IHRoZSBteXNxbCBzZXJ2ZXIsIHdoaWNoIGhhbmRsZXMgaXQgZmluZS4KPj4+ Pgo+Pj4+VGhlIG1h
bnVhbCBkb2VzIG1lbnRpb24gaXQsIEknbSBhIGxpdHRsZSB0b28gcXVpY2sg d2l0aCBteSByZXBs
aWVzLiBJCj4+Pj5wZXJzb25hbGx5IG5ldmVyIGhhZCBhIHByb2JsZW0gd2l0 aCBpdCB0aG91Z2gu
IFBsdXMsIGl0IHNlZW1lZCB0bwo+Pj4+d29yayBzb21lIG1haWxzIGFnby4K Pj4+Pgo+Pj4+RGF2
aWQsIGRpZCBJIHVuZGVyc3RhbmQgd2VsbCB0aGF0IHlvdXIgcHJvYmxlbSBp cyBzb2x2ZWQ/Cj4+
Pj4KPj4+Cj4+Pgo+Pj4gLS0KPj4+IFBIUCBEYXRhYmFzZSBNYWlsaW5nIExp c3QgKGh0dHA6Ly93
d3cucGhwLm5ldC8pCj4+PiBUbyB1bnN1YnNjcmliZSwgdmlzaXQ6IGh0dHA6 Ly93d3cucGhwLm5l
dC91bnN1Yi5waHAKPj4+Cj4+Pgo+Cj4KPiAtLQo+IFBIUCBEYXRhYmFzZSBN YWlsaW5nIExpc3Qg
KGh0dHA6Ly93d3cucGhwLm5ldC8pCj4gVG8gdW5zdWJzY3JpYmUsIHZpc2l0 OiBodHRwOi8vd3d3
LnBocC5uZXQvdW5zdWIucGhwCj4KPgo=

Re: Probleme with MySQL queries

Bonjour,

Yes DELETE is executed and I have on my page :=20
string(3) "140"
int(0)

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 20:51:49 +0200
"Evert Lammerts" a =E9crit:

>But the DELETE is executed? If it is, and it's in the condition, like
>in the above code:
>
>if ($row =3D mysql_fetch_assoc($query)) {
> .... DELETE ...
>}
>
>something apparently is fetched....
>
>On Wed, Sep 3, 2008 at 8:49 PM, David DURIEUX
> wrote:
>> Bonjour,
>>
>> Yes I'm using this query.... and no row select
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>>
>> Le Wed, 3 Sep 2008 20:43:25 +0200
>> "Evert Lammerts" a =E9crit:
>>
>>>Are you still using the code we talked about?
>>>
>>>if ($row =3D mysql_fetch_assoc($query)) {
>>> var_dump ($row);
>>> mysql_query("DELETE FROM table WHERE id=3D{$row['id']}") or
>>>die("delete error: " . mysql_error());
>>>}
>>>
>>>if so, apparently it does fetch a row. Otherwise, can you send the
>>>code you're using?
>>>
>>>On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
>>> wrote:
>>>> Bonjour,
>>>>
>>>> I have always the problem, select =3D 0 rows and it delete it like if
>>>> delete is before the select :/
>>>>
>>>> Cordialement,
>>>>
>>>> David DURIEUX
>>>> Tel : 04.74.04.81.34
>>>> Port : 06.34.99.45.18
>>>> Mail : d.durieux@siprossii.com
>>>> Site Web : http://www.siprossii.com/
>>>>
>>>> SIPROSSII
>>>> 847 route de Frans (Cr=E9acit=E9)
>>>> 69400 Villefranche sur Sa=F4ne
>>>>
>>>>
>>>>
>>>> Le Wed, 3 Sep 2008 20:05:22 +0200
>>>> "Evert Lammerts" a =E9crit:
>>>>
>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>>>>> wrote:
>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy
>>>>>> wrote:
>>>>>>> When using mysql_query, the SQL string to be executed should not
>>>>>>> end in a semicolon.
>>>>>>
>>>>>> Ending a query with a semicolon should not be a problem - the
>>>>>> string is parsed by the mysql server, which handles it fine.
>>>>>
>>>>>The manual does mention it, I'm a little too quick with my
>>>>>replies. I personally never had a problem with it though. Plus, it
>>>>>seemed to work some mails ago.
>>>>>
>>>>>David, did I understand well that your problem is solved?
>>>>>
>>>>
>>>>
>>>> --
>>>> PHP Database Mailing List (http://www.php.net/)
>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>
>>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Can you turn on mysql query logging and see what is actually happening?

Thank you,
Micah Gersten
onShore Networks
Internal Developer
http://www.onshore.com



David DURIEUX wrote:
> Bonjour,
>
> Yes I'm using this query.... and no row select
>
> Cordialement,
>
> David DURIEUX
> Tel : 04.74.04.81.34
> Port : 06.34.99.45.18
> Mail : d.durieux@siprossii.com
> Site Web : http://www.siprossii.com/
>
> SIPROSSII
> 847 route de Frans (Créacité)
> 69400 Villefranche sur Saône
>
>
>
> Le Wed, 3 Sep 2008 20:43:25 +0200
> "Evert Lammerts" a écrit:
>
>
>> Are you still using the code we talked about?
>>
>> if ($row = mysql_fetch_assoc($query)) {
>> var_dump ($row);
>> mysql_query("DELETE FROM table WHERE id={$row['id']}") or
>> die("delete error: " . mysql_error());
>> }
>>
>> if so, apparently it does fetch a row. Otherwise, can you send the
>> code you're using?
>>
>> On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
>> wrote:
>>
>>> Bonjour,
>>>
>>> I have always the problem, select = 0 rows and it delete it like if
>>> delete is before the select :/
>>>
>>> Cordialement,
>>>
>>> David DURIEUX
>>> Tel : 04.74.04.81.34
>>> Port : 06.34.99.45.18
>>> Mail : d.durieux@siprossii.com
>>> Site Web : http://www.siprossii.com/
>>>
>>> SIPROSSII
>>> 847 route de Frans (Créacité)
>>> 69400 Villefranche sur Saône
>>>
>>>
>>>
>>> Le Wed, 3 Sep 2008 20:05:22 +0200
>>> "Evert Lammerts" a écrit:
>>>
>>>
>>>> On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>>>> wrote:
>>>>
>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy wrote:
>>>>>
>>>>>> When using mysql_query, the SQL string to be executed should not
>>>>>> end in a semicolon.
>>>>>>
>>>>> Ending a query with a semicolon should not be a problem - the
>>>>> string is parsed by the mysql server, which handles it fine.
>>>>>
>>>> The manual does mention it, I'm a little too quick with my replies. I
>>>> personally never had a problem with it though. Plus, it seemed to
>>>> work some mails ago.
>>>>
>>>> David, did I understand well that your problem is solved?
>>>>
>>>>
>>> --
>>> PHP Database Mailing List (http://www.php.net/)
>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>
>>>
>>>
>
>
>

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

VGhpcyBpcyB3ZWlyZC4gQ2FuIHlvdSBzZW5kIG92ZXIgdGhlIGNvbXBsZXRl IGZpbGU/CgpPbiBX
ZWQsIFNlcCAzLCAyMDA4IGF0IDg6NTYgUE0sIERhdmlkIERVUklFVVggPGQu ZHVyaWV1eEBzaXBy
b3NzaWkuY29tPiB3cm90ZToKPiBCb25qb3VyLAo+Cj4gWWVzIERFTEVURSBp cyBleGVjdXRlZCBh
bmQgSSBoYXZlIG9uIG15IHBhZ2UgOgo+IHN0cmluZygzKSAiMTQwIgo+IGlu dCgwKQo+Cj4gQ29y
ZGlhbGVtZW50LAo+Cj4gRGF2aWQgRFVSSUVVWAo+IFRlbCA6IDA0Ljc0LjA0 LjgxLjM0Cj4gUG9y
dCA6IDA2LjM0Ljk5LjQ1LjE4Cj4gTWFpbCA6IGQuZHVyaWV1eEBzaXByb3Nz aWkuY29tCj4gU2l0
ZSBXZWIgOiBodHRwOi8vd3d3LnNpcHJvc3NpaS5jb20vCj4KPiBTSVBST1NT SUkKPiA4NDcgcm91
dGUgZGUgRnJhbnMgKENyw6lhY2l0w6kpCj4gNjk0MDAgVmlsbGVmcmFuY2hl IHN1ciBTYcO0bmUK
Pgo+Cj4KPiBMZSBXZWQsIDMgU2VwIDIwMDggMjA6NTE6NDkgKzAyMDAKPiAi RXZlcnQgTGFtbWVy
dHMiIDxldmVydC5sYW1tZXJ0c0BnbWFpbC5jb20+IGEgw6ljcml0Ogo+Cj4+ QnV0IHRoZSBERUxF
VEUgaXMgZXhlY3V0ZWQ/IElmIGl0IGlzLCBhbmQgaXQncyBpbiB0aGUgY29u ZGl0aW9uLCBsaWtl
Cj4+aW4gdGhlIGFib3ZlIGNvZGU6Cj4+Cj4+aWYgKCRyb3cgPSBteXNxbF9m ZXRjaF9hc3NvYygk
cXVlcnkpKSB7Cj4+ICAgLi4uLiBERUxFVEUgLi4uCj4+fQo+Pgo+PnNvbWV0 aGluZyBhcHBhcmVu
dGx5IGlzIGZldGNoZWQuLi4uCj4+Cj4+T24gV2VkLCBTZXAgMywgMjAwOCBh dCA4OjQ5IFBNLCBE
YXZpZCBEVVJJRVVYCj4+PGQuZHVyaWV1eEBzaXByb3NzaWkuY29tPiB3cm90 ZToKPj4+IEJvbmpv
dXIsCj4+Pgo+Pj4gWWVzIEknbSB1c2luZyB0aGlzIHF1ZXJ5Li4uLiBhbmQg bm8gcm93IHNlbGVj
dAo+Pj4KPj4+IENvcmRpYWxlbWVudCwKPj4+Cj4+PiBEYXZpZCBEVVJJRVVY Cj4+PiBUZWwgOiAw
NC43NC4wNC44MS4zNAo+Pj4gUG9ydCA6IDA2LjM0Ljk5LjQ1LjE4Cj4+PiBN YWlsIDogZC5kdXJp
ZXV4QHNpcHJvc3NpaS5jb20KPj4+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5z aXByb3NzaWkuY29t
Lwo+Pj4KPj4+IFNJUFJPU1NJSQo+Pj4gODQ3IHJvdXRlIGRlIEZyYW5zIChD csOpYWNpdMOpKQo+
Pj4gNjk0MDAgVmlsbGVmcmFuY2hlIHN1ciBTYcO0bmUKPj4+Cj4+Pgo+Pj4K Pj4+IExlIFdlZCwg
MyBTZXAgMjAwOCAyMDo0MzoyNSArMDIwMAo+Pj4gIkV2ZXJ0IExhbW1lcnRz IiA8ZXZlcnQubGFt
bWVydHNAZ21haWwuY29tPiBhIMOpY3JpdDoKPj4+Cj4+Pj5BcmUgeW91IHN0 aWxsIHVzaW5nIHRo
ZSBjb2RlIHdlIHRhbGtlZCBhYm91dD8KPj4+Pgo+Pj4+aWYgKCRyb3cgPSBt eXNxbF9mZXRjaF9h
c3NvYygkcXVlcnkpKSB7Cj4+Pj4gICAgICAgICAgIHZhcl9kdW1wICgkcm93 KTsKPj4+PiAgICAg
ICAgICAgbXlzcWxfcXVlcnkoIkRFTEVURSBGUk9NIHRhYmxlIFdIRVJFIGlk PXskcm93WydpZCdd
fSIpIG9yCj4+Pj5kaWUoImRlbGV0ZSBlcnJvcjogIiAuIG15c3FsX2Vycm9y KCkpOwo+Pj4+fQo+
Pj4+Cj4+Pj5pZiBzbywgYXBwYXJlbnRseSBpdCBkb2VzIGZldGNoIGEgcm93 LiBPdGhlcndpc2Us
IGNhbiB5b3Ugc2VuZCB0aGUKPj4+PmNvZGUgeW91J3JlIHVzaW5nPwo+Pj4+ Cj4+Pj5PbiBXZWQs
IFNlcCAzLCAyMDA4IGF0IDg6MzUgUE0sIERhdmlkIERVUklFVVgKPj4+Pjxk LmR1cmlldXhAc2lw
cm9zc2lpLmNvbT4gd3JvdGU6Cj4+Pj4+IEJvbmpvdXIsCj4+Pj4+Cj4+Pj4+ IEkgaGF2ZSBhbHdh
eXMgdGhlIHByb2JsZW0sIHNlbGVjdCA9IDAgcm93cyBhbmQgaXQgZGVsZXRl IGl0IGxpa2UgaWYK
Pj4+Pj4gZGVsZXRlIGlzIGJlZm9yZSB0aGUgc2VsZWN0IDovCj4+Pj4+Cj4+ Pj4+IENvcmRpYWxl
bWVudCwKPj4+Pj4KPj4+Pj4gRGF2aWQgRFVSSUVVWAo+Pj4+PiBUZWwgOiAw NC43NC4wNC44MS4z
NAo+Pj4+PiBQb3J0IDogMDYuMzQuOTkuNDUuMTgKPj4+Pj4gTWFpbCA6IGQu ZHVyaWV1eEBzaXBy
b3NzaWkuY29tCj4+Pj4+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXByb3Nz aWkuY29tLwo+Pj4+
Pgo+Pj4+PiBTSVBST1NTSUkKPj4+Pj4gODQ3IHJvdXRlIGRlIEZyYW5zIChD csOpYWNpdMOpKQo+
Pj4+PiA2OTQwMCBWaWxsZWZyYW5jaGUgc3VyIFNhw7RuZQo+Pj4+Pgo+Pj4+ Pgo+Pj4+Pgo+Pj4+
PiBMZSBXZWQsIDMgU2VwIDIwMDggMjA6MDU6MjIgKzAyMDAKPj4+Pj4gIkV2 ZXJ0IExhbW1lcnRz
IiA8ZXZlcnQubGFtbWVydHNAZ21haWwuY29tPiBhIMOpY3JpdDoKPj4+Pj4K Pj4+Pj4+T24gV2Vk
LCBTZXAgMywgMjAwOCBhdCA3OjU4IFBNLCBFdmVydCBMYW1tZXJ0cwo+Pj4+ Pj48ZXZlcnQubGFt
bWVydHNAZ21haWwuY29tPiB3cm90ZToKPj4+Pj4+PiBPbiBXZWQsIFNlcCAz LCAyMDA4IGF0IDc6
NDEgUE0sIERlZSBBeXkgPGRlZS5heXlAZ21haWwuY29tPgo+Pj4+Pj4+IHdy b3RlOgo+Pj4+Pj4+
PiBXaGVuIHVzaW5nIG15c3FsX3F1ZXJ5LCB0aGUgU1FMIHN0cmluZyB0byBi ZSBleGVjdXRlZCBz
aG91bGQgbm90Cj4+Pj4+Pj4+IGVuZCBpbiBhIHNlbWljb2xvbi4KPj4+Pj4+ Pgo+Pj4+Pj4+IEVu
ZGluZyBhIHF1ZXJ5IHdpdGggYSBzZW1pY29sb24gc2hvdWxkIG5vdCBiZSBh IHByb2JsZW0gLSB0
aGUKPj4+Pj4+PiBzdHJpbmcgaXMgcGFyc2VkIGJ5IHRoZSBteXNxbCBzZXJ2 ZXIsIHdoaWNoIGhh
bmRsZXMgaXQgZmluZS4KPj4+Pj4+Cj4+Pj4+PlRoZSBtYW51YWwgZG9lcyBt ZW50aW9uIGl0LCBJ
J20gYSBsaXR0bGUgdG9vIHF1aWNrIHdpdGggbXkKPj4+Pj4+cmVwbGllcy4g SSBwZXJzb25hbGx5
IG5ldmVyIGhhZCBhIHByb2JsZW0gd2l0aCBpdCB0aG91Z2guIFBsdXMsIGl0 Cj4+Pj4+PnNlZW1l
ZCB0byB3b3JrIHNvbWUgbWFpbHMgYWdvLgo+Pj4+Pj4KPj4+Pj4+RGF2aWQs IGRpZCBJIHVuZGVy
c3RhbmQgd2VsbCB0aGF0IHlvdXIgcHJvYmxlbSBpcyBzb2x2ZWQ/Cj4+Pj4+ Pgo+Pj4+Pgo+Pj4+
Pgo+Pj4+PiAtLQo+Pj4+PiBQSFAgRGF0YWJhc2UgTWFpbGluZyBMaXN0ICho dHRwOi8vd3d3LnBo
cC5uZXQvKQo+Pj4+PiBUbyB1bnN1YnNjcmliZSwgdmlzaXQ6IGh0dHA6Ly93 d3cucGhwLm5ldC91
bnN1Yi5waHAKPj4+Pj4KPj4+Pj4KPj4+Cj4+Pgo+Pj4gLS0KPj4+IFBIUCBE YXRhYmFzZSBNYWls
aW5nIExpc3QgKGh0dHA6Ly93d3cucGhwLm5ldC8pCj4+PiBUbyB1bnN1YnNj cmliZSwgdmlzaXQ6
IGh0dHA6Ly93d3cucGhwLm5ldC91bnN1Yi5waHAKPj4+Cj4+Pgo+Cj4K

Re: Probleme with MySQL queries

Bonjour,

It was difficult, I have many files in includes, I will try to execute
this code before in the php execution to see what code give problem.

I try this now and I tell you the results of investigations


Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 21:01:14 +0200
"Evert Lammerts" a =E9crit:

>This is weird. Can you send over the complete file?
>
>On Wed, Sep 3, 2008 at 8:56 PM, David DURIEUX
> wrote:
>> Bonjour,
>>
>> Yes DELETE is executed and I have on my page :
>> string(3) "140"
>> int(0)
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>>
>> Le Wed, 3 Sep 2008 20:51:49 +0200
>> "Evert Lammerts" a =E9crit:
>>
>>>But the DELETE is executed? If it is, and it's in the condition, like
>>>in the above code:
>>>
>>>if ($row =3D mysql_fetch_assoc($query)) {
>>> .... DELETE ...
>>>}
>>>
>>>something apparently is fetched....
>>>
>>>On Wed, Sep 3, 2008 at 8:49 PM, David DURIEUX
>>> wrote:
>>>> Bonjour,
>>>>
>>>> Yes I'm using this query.... and no row select
>>>>
>>>> Cordialement,
>>>>
>>>> David DURIEUX
>>>> Tel : 04.74.04.81.34
>>>> Port : 06.34.99.45.18
>>>> Mail : d.durieux@siprossii.com
>>>> Site Web : http://www.siprossii.com/
>>>>
>>>> SIPROSSII
>>>> 847 route de Frans (Cr=E9acit=E9)
>>>> 69400 Villefranche sur Sa=F4ne
>>>>
>>>>
>>>>
>>>> Le Wed, 3 Sep 2008 20:43:25 +0200
>>>> "Evert Lammerts" a =E9crit:
>>>>
>>>>>Are you still using the code we talked about?
>>>>>
>>>>>if ($row =3D mysql_fetch_assoc($query)) {
>>>>> var_dump ($row);
>>>>> mysql_query("DELETE FROM table WHERE id=3D{$row['id']}")
>>>>> or
>>>>>die("delete error: " . mysql_error());
>>>>>}
>>>>>
>>>>>if so, apparently it does fetch a row. Otherwise, can you send the
>>>>>code you're using?
>>>>>
>>>>>On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
>>>>> wrote:
>>>>>> Bonjour,
>>>>>>
>>>>>> I have always the problem, select =3D 0 rows and it delete it like
>>>>>> if delete is before the select :/
>>>>>>
>>>>>> Cordialement,
>>>>>>
>>>>>> David DURIEUX
>>>>>> Tel : 04.74.04.81.34
>>>>>> Port : 06.34.99.45.18
>>>>>> Mail : d.durieux@siprossii.com
>>>>>> Site Web : http://www.siprossii.com/
>>>>>>
>>>>>> SIPROSSII
>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>
>>>>>>
>>>>>>
>>>>>> Le Wed, 3 Sep 2008 20:05:22 +0200
>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>
>>>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>>>>>>> wrote:
>>>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy
>>>>>>>> wrote:
>>>>>>>>> When using mysql_query, the SQL string to be executed should
>>>>>>>>> not end in a semicolon.
>>>>>>>>
>>>>>>>> Ending a query with a semicolon should not be a problem - the
>>>>>>>> string is parsed by the mysql server, which handles it fine.
>>>>>>>
>>>>>>>The manual does mention it, I'm a little too quick with my
>>>>>>>replies. I personally never had a problem with it though. Plus,
>>>>>>>it seemed to work some mails ago.
>>>>>>>
>>>>>>>David, did I understand well that your problem is solved?
>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>
>>>>>>
>>>>
>>>>
>>>> --
>>>> PHP Database Mailing List (http://www.php.net/)
>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>
>>>>
>>
>>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

> Your SELECT has a terminating semicolon.

I'm guessing Multiple statement execution is enabled by default...
http://dev.mysql.com/doc/refman/5.0/en/mysql-query.html

--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

Humm if I go on page index.php?deleteid=3D139=20
it works

If I click on the link type=3D"submit" value=3D"Supprimer" style=3D"width: 100px; " />
I have the SELECT problem

I will be crazy=20

Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 21:08:25 +0200
David DURIEUX a =E9crit:

>Bonjour,
>
>It was difficult, I have many files in includes, I will try to execute
>this code before in the php execution to see what code give problem.
>
>I try this now and I tell you the results of investigations
>
>
>Cordialement,
>
>David DURIEUX
>Tel : 04.74.04.81.34
>Port : 06.34.99.45.18
>Mail : d.durieux@siprossii.com
>Site Web : http://www.siprossii.com/
>
>SIPROSSII
>847 route de Frans (Cr=E9acit=E9)
>69400 Villefranche sur Sa=F4ne
>
>
>
>Le Wed, 3 Sep 2008 21:01:14 +0200
>"Evert Lammerts" a =E9crit:
>
>>This is weird. Can you send over the complete file?
>>
>>On Wed, Sep 3, 2008 at 8:56 PM, David DURIEUX
>> wrote:
>>> Bonjour,
>>>
>>> Yes DELETE is executed and I have on my page :
>>> string(3) "140"
>>> int(0)
>>>
>>> Cordialement,
>>>
>>> David DURIEUX
>>> Tel : 04.74.04.81.34
>>> Port : 06.34.99.45.18
>>> Mail : d.durieux@siprossii.com
>>> Site Web : http://www.siprossii.com/
>>>
>>> SIPROSSII
>>> 847 route de Frans (Cr=E9acit=E9)
>>> 69400 Villefranche sur Sa=F4ne
>>>
>>>
>>>
>>> Le Wed, 3 Sep 2008 20:51:49 +0200
>>> "Evert Lammerts" a =E9crit:
>>>
>>>>But the DELETE is executed? If it is, and it's in the condition,
>>>>like in the above code:
>>>>
>>>>if ($row =3D mysql_fetch_assoc($query)) {
>>>> .... DELETE ...
>>>>}
>>>>
>>>>something apparently is fetched....
>>>>
>>>>On Wed, Sep 3, 2008 at 8:49 PM, David DURIEUX
>>>> wrote:
>>>>> Bonjour,
>>>>>
>>>>> Yes I'm using this query.... and no row select
>>>>>
>>>>> Cordialement,
>>>>>
>>>>> David DURIEUX
>>>>> Tel : 04.74.04.81.34
>>>>> Port : 06.34.99.45.18
>>>>> Mail : d.durieux@siprossii.com
>>>>> Site Web : http://www.siprossii.com/
>>>>>
>>>>> SIPROSSII
>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>
>>>>>
>>>>>
>>>>> Le Wed, 3 Sep 2008 20:43:25 +0200
>>>>> "Evert Lammerts" a =E9crit:
>>>>>
>>>>>>Are you still using the code we talked about?
>>>>>>
>>>>>>if ($row =3D mysql_fetch_assoc($query)) {
>>>>>> var_dump ($row);
>>>>>> mysql_query("DELETE FROM table WHERE id=3D{$row['id']}")
>>>>>> or
>>>>>>die("delete error: " . mysql_error());
>>>>>>}
>>>>>>
>>>>>>if so, apparently it does fetch a row. Otherwise, can you send the
>>>>>>code you're using?
>>>>>>
>>>>>>On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
>>>>>> wrote:
>>>>>>> Bonjour,
>>>>>>>
>>>>>>> I have always the problem, select =3D 0 rows and it delete it like
>>>>>>> if delete is before the select :/
>>>>>>>
>>>>>>> Cordialement,
>>>>>>>
>>>>>>> David DURIEUX
>>>>>>> Tel : 04.74.04.81.34
>>>>>>> Port : 06.34.99.45.18
>>>>>>> Mail : d.durieux@siprossii.com
>>>>>>> Site Web : http://www.siprossii.com/
>>>>>>>
>>>>>>> SIPROSSII
>>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Le Wed, 3 Sep 2008 20:05:22 +0200
>>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>>
>>>>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>>>>>>>> wrote:
>>>>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy
>>>>>>>>> wrote:
>>>>>>>>>> When using mysql_query, the SQL string to be executed should
>>>>>>>>>> not end in a semicolon.
>>>>>>>>>
>>>>>>>>> Ending a query with a semicolon should not be a problem - the
>>>>>>>>> string is parsed by the mysql server, which handles it fine.
>>>>>>>>
>>>>>>>>The manual does mention it, I'm a little too quick with my
>>>>>>>>replies. I personally never had a problem with it though. Plus,
>>>>>>>>it seemed to work some mails ago.
>>>>>>>>
>>>>>>>>David, did I understand well that your problem is solved?
>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>>> --
>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>
>>>>>
>>>
>>>
>
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

Bonjour,

The problem come from the in the input submit

With It works

It is very Space



Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 21:50:42 +0200
David DURIEUX a =E9crit:

>Bonjour,
>
>Humm if I go on page index.php?deleteid=3D139=20
>it works
>
>If I click on the link >type=3D"submit" value=3D"Supprimer" style=3D"width: 100px; " />
>I have the SELECT problem
>
>I will be crazy=20
>
>Cordialement,
>
>David DURIEUX
>Tel : 04.74.04.81.34
>Port : 06.34.99.45.18
>Mail : d.durieux@siprossii.com
>Site Web : http://www.siprossii.com/
>
>SIPROSSII
>847 route de Frans (Cr=E9acit=E9)
>69400 Villefranche sur Sa=F4ne
>
>
>
>Le Wed, 3 Sep 2008 21:08:25 +0200
>David DURIEUX a =E9crit:
>
>>Bonjour,
>>
>>It was difficult, I have many files in includes, I will try to execute
>>this code before in the php execution to see what code give problem.
>>
>>I try this now and I tell you the results of investigations
>>
>>
>>Cordialement,
>>
>>David DURIEUX
>>Tel : 04.74.04.81.34
>>Port : 06.34.99.45.18
>>Mail : d.durieux@siprossii.com
>>Site Web : http://www.siprossii.com/
>>
>>SIPROSSII
>>847 route de Frans (Cr=E9acit=E9)
>>69400 Villefranche sur Sa=F4ne
>>
>>
>>
>>Le Wed, 3 Sep 2008 21:01:14 +0200
>>"Evert Lammerts" a =E9crit:
>>
>>>This is weird. Can you send over the complete file?
>>>
>>>On Wed, Sep 3, 2008 at 8:56 PM, David DURIEUX
>>> wrote:
>>>> Bonjour,
>>>>
>>>> Yes DELETE is executed and I have on my page :
>>>> string(3) "140"
>>>> int(0)
>>>>
>>>> Cordialement,
>>>>
>>>> David DURIEUX
>>>> Tel : 04.74.04.81.34
>>>> Port : 06.34.99.45.18
>>>> Mail : d.durieux@siprossii.com
>>>> Site Web : http://www.siprossii.com/
>>>>
>>>> SIPROSSII
>>>> 847 route de Frans (Cr=E9acit=E9)
>>>> 69400 Villefranche sur Sa=F4ne
>>>>
>>>>
>>>>
>>>> Le Wed, 3 Sep 2008 20:51:49 +0200
>>>> "Evert Lammerts" a =E9crit:
>>>>
>>>>>But the DELETE is executed? If it is, and it's in the condition,
>>>>>like in the above code:
>>>>>
>>>>>if ($row =3D mysql_fetch_assoc($query)) {
>>>>> .... DELETE ...
>>>>>}
>>>>>
>>>>>something apparently is fetched....
>>>>>
>>>>>On Wed, Sep 3, 2008 at 8:49 PM, David DURIEUX
>>>>> wrote:
>>>>>> Bonjour,
>>>>>>
>>>>>> Yes I'm using this query.... and no row select
>>>>>>
>>>>>> Cordialement,
>>>>>>
>>>>>> David DURIEUX
>>>>>> Tel : 04.74.04.81.34
>>>>>> Port : 06.34.99.45.18
>>>>>> Mail : d.durieux@siprossii.com
>>>>>> Site Web : http://www.siprossii.com/
>>>>>>
>>>>>> SIPROSSII
>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>
>>>>>>
>>>>>>
>>>>>> Le Wed, 3 Sep 2008 20:43:25 +0200
>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>
>>>>>>>Are you still using the code we talked about?
>>>>>>>
>>>>>>>if ($row =3D mysql_fetch_assoc($query)) {
>>>>>>> var_dump ($row);
>>>>>>> mysql_query("DELETE FROM table WHERE id=3D{$row['id']}")
>>>>>>> or
>>>>>>>die("delete error: " . mysql_error());
>>>>>>>}
>>>>>>>
>>>>>>>if so, apparently it does fetch a row. Otherwise, can you send
>>>>>>>the code you're using?
>>>>>>>
>>>>>>>On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
>>>>>>> wrote:
>>>>>>>> Bonjour,
>>>>>>>>
>>>>>>>> I have always the problem, select =3D 0 rows and it delete it
>>>>>>>> like if delete is before the select :/
>>>>>>>>
>>>>>>>> Cordialement,
>>>>>>>>
>>>>>>>> David DURIEUX
>>>>>>>> Tel : 04.74.04.81.34
>>>>>>>> Port : 06.34.99.45.18
>>>>>>>> Mail : d.durieux@siprossii.com
>>>>>>>> Site Web : http://www.siprossii.com/
>>>>>>>>
>>>>>>>> SIPROSSII
>>>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> Le Wed, 3 Sep 2008 20:05:22 +0200
>>>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>>>
>>>>>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>>>>>>>>> wrote:
>>>>>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy
>>>>>>>>>> wrote:
>>>>>>>>>>> When using mysql_query, the SQL string to be executed should
>>>>>>>>>>> not end in a semicolon.
>>>>>>>>>>
>>>>>>>>>> Ending a query with a semicolon should not be a problem - the
>>>>>>>>>> string is parsed by the mysql server, which handles it fine.
>>>>>>>>>
>>>>>>>>>The manual does mention it, I'm a little too quick with my
>>>>>>>>>replies. I personally never had a problem with it though. Plus,
>>>>>>>>>it seemed to work some mails ago.
>>>>>>>>>
>>>>>>>>>David, did I understand well that your problem is solved?
>>>>>>>>>
>>>>>>>>
>>>>>>>>
>>>>>>>> --
>>>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>>>
>>>>>>>>
>>>>>>
>>>>>>
>>>>>> --
>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>
>>>>>>
>>>>
>>>>
>>
>>
>
>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php

Re: Probleme with MySQL queries

YW4gYW5jaG9yIGFyb3VuZCBhIHN1Ym1pdCBidXR0b24uLi4uLi4uLi4uLj8/ IEknbSBhbWF6ZWQg
dGhhdCB3b3JrcyEhIDotKQoKQSByZWFsIGxpbmsgZG9lc24ndCBtYWtlIGEg ZGlmZmVyZW5jZT8K
CjxhIGhyZWY9ImluZGV4LnBocD9kZWxldGVpZD0xMzkiPkRFTEVURTwvYT4K CltNYWtlIHN1cmUg
dG8gcmVwbGFjZSAxMzkgd2l0aCBhbiBleGlzdGluZyBpZC4uLl0KCk9uIFdl ZCwgU2VwIDMsIDIw
MDggYXQgOTo1MCBQTSwgRGF2aWQgRFVSSUVVWCA8ZC5kdXJpZXV4QHNpcHJv c3NpaS5jb20+IHdy
b3RlOgo+IEJvbmpvdXIsCj4KPiBIdW1tIGlmIEkgZ28gb24gcGFnZSBpbmRl eC5waHA/ZGVsZXRl
aWQ9MTM5Cj4gaXQgd29ya3MKPgo+IElmIEkgY2xpY2sgb24gdGhlIGxpbmsg PGEgaHJlZj0iaW5k
ZXgucGhwP2RlbGV0ZWlkPTEzOSI+PGlucHV0Cj4gdHlwZT0ic3VibWl0IiB2 YWx1ZT0iU3VwcHJp
bWVyIiBzdHlsZT0id2lkdGg6IDEwMHB4OyAiIC8+PC9hPgo+IEkgaGF2ZSB0 aGUgU0VMRUNUIHBy
b2JsZW0KPgo+IEkgd2lsbCBiZSBjcmF6eQo+Cj4gQ29yZGlhbGVtZW50LAo+ Cj4gRGF2aWQgRFVS
SUVVWAo+IFRlbCA6IDA0Ljc0LjA0LjgxLjM0Cj4gUG9ydCA6IDA2LjM0Ljk5 LjQ1LjE4Cj4gTWFp
bCA6IGQuZHVyaWV1eEBzaXByb3NzaWkuY29tCj4gU2l0ZSBXZWIgOiBodHRw Oi8vd3d3LnNpcHJv
c3NpaS5jb20vCj4KPiBTSVBST1NTSUkKPiA4NDcgcm91dGUgZGUgRnJhbnMg KENyw6lhY2l0w6kp
Cj4gNjk0MDAgVmlsbGVmcmFuY2hlIHN1ciBTYcO0bmUKPgo+Cj4KPiBMZSBX ZWQsIDMgU2VwIDIw
MDggMjE6MDg6MjUgKzAyMDAKPiBEYXZpZCBEVVJJRVVYIDxkLmR1cmlldXhA c2lwcm9zc2lpLmNv
bT4gYSDDqWNyaXQ6Cj4KPj5Cb25qb3VyLAo+Pgo+Pkl0IHdhcyBkaWZmaWN1 bHQsIEkgaGF2ZSBt
YW55IGZpbGVzIGluIGluY2x1ZGVzLCBJIHdpbGwgdHJ5IHRvIGV4ZWN1dGUK Pj50aGlzIGNvZGUg
YmVmb3JlIGluIHRoZSBwaHAgZXhlY3V0aW9uIHRvIHNlZSB3aGF0IGNvZGUg Z2l2ZSBwcm9ibGVt
Lgo+Pgo+PkkgdHJ5IHRoaXMgbm93IGFuZCBJIHRlbGwgeW91IHRoZSByZXN1 bHRzIG9mIGludmVz
dGlnYXRpb25zCj4+Cj4+Cj4+Q29yZGlhbGVtZW50LAo+Pgo+PkRhdmlkIERV UklFVVgKPj5UZWwg
OiAwNC43NC4wNC44MS4zNAo+PlBvcnQgOiAwNi4zNC45OS40NS4xOAo+Pk1h aWwgOiBkLmR1cmll
dXhAc2lwcm9zc2lpLmNvbQo+PlNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXBy b3NzaWkuY29tLwo+
Pgo+PlNJUFJPU1NJSQo+Pjg0NyByb3V0ZSBkZSBGcmFucyAoQ3LDqWFjaXTD qSkKPj42OTQwMCBW
aWxsZWZyYW5jaGUgc3VyIFNhw7RuZQo+Pgo+Pgo+Pgo+PkxlIFdlZCwgMyBT ZXAgMjAwOCAyMTow
MToxNCArMDIwMAo+PiJFdmVydCBMYW1tZXJ0cyIgPGV2ZXJ0LmxhbW1lcnRz QGdtYWlsLmNvbT4g
YSDDqWNyaXQ6Cj4+Cj4+PlRoaXMgaXMgd2VpcmQuIENhbiB5b3Ugc2VuZCBv dmVyIHRoZSBjb21w
bGV0ZSBmaWxlPwo+Pj4KPj4+T24gV2VkLCBTZXAgMywgMjAwOCBhdCA4OjU2 IFBNLCBEYXZpZCBE
VVJJRVVYCj4+PjxkLmR1cmlldXhAc2lwcm9zc2lpLmNvbT4gd3JvdGU6Cj4+ Pj4gQm9uam91ciwK
Pj4+Pgo+Pj4+IFllcyBERUxFVEUgaXMgZXhlY3V0ZWQgYW5kIEkgaGF2ZSBv biBteSBwYWdlIDoK
Pj4+PiBzdHJpbmcoMykgIjE0MCIKPj4+PiBpbnQoMCkKPj4+Pgo+Pj4+IENv cmRpYWxlbWVudCwK
Pj4+Pgo+Pj4+IERhdmlkIERVUklFVVgKPj4+PiBUZWwgOiAwNC43NC4wNC44 MS4zNAo+Pj4+IFBv
cnQgOiAwNi4zNC45OS40NS4xOAo+Pj4+IE1haWwgOiBkLmR1cmlldXhAc2lw cm9zc2lpLmNvbQo+
Pj4+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXByb3NzaWkuY29tLwo+Pj4+ Cj4+Pj4gU0lQUk9T
U0lJCj4+Pj4gODQ3IHJvdXRlIGRlIEZyYW5zIChDcsOpYWNpdMOpKQo+Pj4+ IDY5NDAwIFZpbGxl
ZnJhbmNoZSBzdXIgU2HDtG5lCj4+Pj4KPj4+Pgo+Pj4+Cj4+Pj4gTGUgV2Vk LCAzIFNlcCAyMDA4
IDIwOjUxOjQ5ICswMjAwCj4+Pj4gIkV2ZXJ0IExhbW1lcnRzIiA8ZXZlcnQu bGFtbWVydHNAZ21h
aWwuY29tPiBhIMOpY3JpdDoKPj4+Pgo+Pj4+PkJ1dCB0aGUgREVMRVRFIGlz IGV4ZWN1dGVkPyBJ
ZiBpdCBpcywgYW5kIGl0J3MgaW4gdGhlIGNvbmRpdGlvbiwKPj4+Pj5saWtl IGluIHRoZSBhYm92
ZSBjb2RlOgo+Pj4+Pgo+Pj4+PmlmICgkcm93ID0gbXlzcWxfZmV0Y2hfYXNz b2MoJHF1ZXJ5KSkg
ewo+Pj4+PiAgIC4uLi4gREVMRVRFIC4uLgo+Pj4+Pn0KPj4+Pj4KPj4+Pj5z b21ldGhpbmcgYXBw
YXJlbnRseSBpcyBmZXRjaGVkLi4uLgo+Pj4+Pgo+Pj4+Pk9uIFdlZCwgU2Vw IDMsIDIwMDggYXQg
ODo0OSBQTSwgRGF2aWQgRFVSSUVVWAo+Pj4+PjxkLmR1cmlldXhAc2lwcm9z c2lpLmNvbT4gd3Jv
dGU6Cj4+Pj4+PiBCb25qb3VyLAo+Pj4+Pj4KPj4+Pj4+IFllcyBJJ20gdXNp bmcgdGhpcyBxdWVy
eS4uLi4gYW5kIG5vIHJvdyBzZWxlY3QKPj4+Pj4+Cj4+Pj4+PiBDb3JkaWFs ZW1lbnQsCj4+Pj4+
Pgo+Pj4+Pj4gRGF2aWQgRFVSSUVVWAo+Pj4+Pj4gVGVsIDogMDQuNzQuMDQu ODEuMzQKPj4+Pj4+
IFBvcnQgOiAwNi4zNC45OS40NS4xOAo+Pj4+Pj4gTWFpbCA6IGQuZHVyaWV1 eEBzaXByb3NzaWku
Y29tCj4+Pj4+PiBTaXRlIFdlYiA6IGh0dHA6Ly93d3cuc2lwcm9zc2lpLmNv bS8KPj4+Pj4+Cj4+
Pj4+PiBTSVBST1NTSUkKPj4+Pj4+IDg0NyByb3V0ZSBkZSBGcmFucyAoQ3LD qWFjaXTDqSkKPj4+
Pj4+IDY5NDAwIFZpbGxlZnJhbmNoZSBzdXIgU2HDtG5lCj4+Pj4+Pgo+Pj4+ Pj4KPj4+Pj4+Cj4+
Pj4+PiBMZSBXZWQsIDMgU2VwIDIwMDggMjA6NDM6MjUgKzAyMDAKPj4+Pj4+ ICJFdmVydCBMYW1t
ZXJ0cyIgPGV2ZXJ0LmxhbW1lcnRzQGdtYWlsLmNvbT4gYSDDqWNyaXQ6Cj4+ Pj4+Pgo+Pj4+Pj4+
QXJlIHlvdSBzdGlsbCB1c2luZyB0aGUgY29kZSB3ZSB0YWxrZWQgYWJvdXQ/ Cj4+Pj4+Pj4KPj4+
Pj4+PmlmICgkcm93ID0gbXlzcWxfZmV0Y2hfYXNzb2MoJHF1ZXJ5KSkgewo+ Pj4+Pj4+ICAgICAg
ICAgICB2YXJfZHVtcCAoJHJvdyk7Cj4+Pj4+Pj4gICAgICAgICAgIG15c3Fs X3F1ZXJ5KCJERUxF
VEUgRlJPTSB0YWJsZSBXSEVSRSBpZD17JHJvd1snaWQnXX0iKQo+Pj4+Pj4+ IG9yCj4+Pj4+Pj5k
aWUoImRlbGV0ZSBlcnJvcjogIiAuIG15c3FsX2Vycm9yKCkpOwo+Pj4+Pj4+ fQo+Pj4+Pj4+Cj4+
Pj4+Pj5pZiBzbywgYXBwYXJlbnRseSBpdCBkb2VzIGZldGNoIGEgcm93LiBP dGhlcndpc2UsIGNh
biB5b3Ugc2VuZCB0aGUKPj4+Pj4+PmNvZGUgeW91J3JlIHVzaW5nPwo+Pj4+ Pj4+Cj4+Pj4+Pj5P
biBXZWQsIFNlcCAzLCAyMDA4IGF0IDg6MzUgUE0sIERhdmlkIERVUklFVVgK Pj4+Pj4+PjxkLmR1
cmlldXhAc2lwcm9zc2lpLmNvbT4gd3JvdGU6Cj4+Pj4+Pj4+IEJvbmpvdXIs Cj4+Pj4+Pj4+Cj4+
Pj4+Pj4+IEkgaGF2ZSBhbHdheXMgdGhlIHByb2JsZW0sIHNlbGVjdCA9IDAg cm93cyBhbmQgaXQg
ZGVsZXRlIGl0IGxpa2UKPj4+Pj4+Pj4gaWYgZGVsZXRlIGlzIGJlZm9yZSB0 aGUgc2VsZWN0IDov
Cj4+Pj4+Pj4+Cj4+Pj4+Pj4+IENvcmRpYWxlbWVudCwKPj4+Pj4+Pj4KPj4+ Pj4+Pj4gRGF2aWQg
RFVSSUVVWAo+Pj4+Pj4+PiBUZWwgOiAwNC43NC4wNC44MS4zNAo+Pj4+Pj4+ PiBQb3J0IDogMDYu
MzQuOTkuNDUuMTgKPj4+Pj4+Pj4gTWFpbCA6IGQuZHVyaWV1eEBzaXByb3Nz aWkuY29tCj4+Pj4+
Pj4+IFNpdGUgV2ViIDogaHR0cDovL3d3dy5zaXByb3NzaWkuY29tLwo+Pj4+ Pj4+Pgo+Pj4+Pj4+
PiBTSVBST1NTSUkKPj4+Pj4+Pj4gODQ3IHJvdXRlIGRlIEZyYW5zIChDcsOp YWNpdMOpKQo+Pj4+
Pj4+PiA2OTQwMCBWaWxsZWZyYW5jaGUgc3VyIFNhw7RuZQo+Pj4+Pj4+Pgo+ Pj4+Pj4+Pgo+Pj4+
Pj4+Pgo+Pj4+Pj4+PiBMZSBXZWQsIDMgU2VwIDIwMDggMjA6MDU6MjIgKzAy MDAKPj4+Pj4+Pj4g
IkV2ZXJ0IExhbW1lcnRzIiA8ZXZlcnQubGFtbWVydHNAZ21haWwuY29tPiBh IMOpY3JpdDoKPj4+
Pj4+Pj4KPj4+Pj4+Pj4+T24gV2VkLCBTZXAgMywgMjAwOCBhdCA3OjU4IFBN LCBFdmVydCBMYW1t
ZXJ0cwo+Pj4+Pj4+Pj48ZXZlcnQubGFtbWVydHNAZ21haWwuY29tPiB3cm90 ZToKPj4+Pj4+Pj4+
PiBPbiBXZWQsIFNlcCAzLCAyMDA4IGF0IDc6NDEgUE0sIERlZSBBeXkgPGRl ZS5heXlAZ21haWwu
Y29tPgo+Pj4+Pj4+Pj4+IHdyb3RlOgo+Pj4+Pj4+Pj4+PiBXaGVuIHVzaW5n IG15c3FsX3F1ZXJ5
LCB0aGUgU1FMIHN0cmluZyB0byBiZSBleGVjdXRlZCBzaG91bGQKPj4+Pj4+ Pj4+Pj4gbm90IGVu
ZCBpbiBhIHNlbWljb2xvbi4KPj4+Pj4+Pj4+Pgo+Pj4+Pj4+Pj4+IEVuZGlu ZyBhIHF1ZXJ5IHdp
dGggYSBzZW1pY29sb24gc2hvdWxkIG5vdCBiZSBhIHByb2JsZW0gLSB0aGUK Pj4+Pj4+Pj4+PiBz
dHJpbmcgaXMgcGFyc2VkIGJ5IHRoZSBteXNxbCBzZXJ2ZXIsIHdoaWNoIGhh bmRsZXMgaXQgZmlu
ZS4KPj4+Pj4+Pj4+Cj4+Pj4+Pj4+PlRoZSBtYW51YWwgZG9lcyBtZW50aW9u IGl0LCBJJ20gYSBs
aXR0bGUgdG9vIHF1aWNrIHdpdGggbXkKPj4+Pj4+Pj4+cmVwbGllcy4gSSBw ZXJzb25hbGx5IG5l
dmVyIGhhZCBhIHByb2JsZW0gd2l0aCBpdCB0aG91Z2guIFBsdXMsCj4+Pj4+ Pj4+Pml0IHNlZW1l
ZCB0byB3b3JrIHNvbWUgbWFpbHMgYWdvLgo+Pj4+Pj4+Pj4KPj4+Pj4+Pj4+ RGF2aWQsIGRpZCBJ
IHVuZGVyc3RhbmQgd2VsbCB0aGF0IHlvdXIgcHJvYmxlbSBpcyBzb2x2ZWQ/ Cj4+Pj4+Pj4+Pgo+
Pj4+Pj4+Pgo+Pj4+Pj4+Pgo+Pj4+Pj4+PiAtLQo+Pj4+Pj4+PiBQSFAgRGF0 YWJhc2UgTWFpbGlu
ZyBMaXN0IChodHRwOi8vd3d3LnBocC5uZXQvKQo+Pj4+Pj4+PiBUbyB1bnN1 YnNjcmliZSwgdmlz
aXQ6IGh0dHA6Ly93d3cucGhwLm5ldC91bnN1Yi5waHAKPj4+Pj4+Pj4KPj4+ Pj4+Pj4KPj4+Pj4+
Cj4+Pj4+Pgo+Pj4+Pj4gLS0KPj4+Pj4+IFBIUCBEYXRhYmFzZSBNYWlsaW5n IExpc3QgKGh0dHA6
Ly93d3cucGhwLm5ldC8pCj4+Pj4+PiBUbyB1bnN1YnNjcmliZSwgdmlzaXQ6 IGh0dHA6Ly93d3cu
cGhwLm5ldC91bnN1Yi5waHAKPj4+Pj4+Cj4+Pj4+Pgo+Pj4+Cj4+Pj4KPj4K Pj4KPgo+Cj4gLS0K
PiBQSFAgRGF0YWJhc2UgTWFpbGluZyBMaXN0IChodHRwOi8vd3d3LnBocC5u ZXQvKQo+IFRvIHVu
c3Vic2NyaWJlLCB2aXNpdDogaHR0cDovL3d3dy5waHAubmV0L3Vuc3ViLnBo cAo+Cj4K

Re: Probleme with MySQL queries

Bonjour,


I have make this to have a button, it's an error, it's the first time I
have a problem with this.

I'm sorry to have get your time.


Cordialement,

David DURIEUX
Tel : 04.74.04.81.34
Port : 06.34.99.45.18
Mail : d.durieux@siprossii.com
Site Web : http://www.siprossii.com/

SIPROSSII
847 route de Frans (Cr=E9acit=E9)
69400 Villefranche sur Sa=F4ne



Le Wed, 3 Sep 2008 21:56:56 +0200
"Evert Lammerts" a =E9crit:

>an anchor around a submit button...........?? I'm amazed that
>works!! :-)
>
>A real link doesn't make a difference?
>
>
>
>[Make sure to replace 139 with an existing id...]
>
>On Wed, Sep 3, 2008 at 9:50 PM, David DURIEUX
> wrote:
>> Bonjour,
>>
>> Humm if I go on page index.php?deleteid=3D139
>> it works
>>
>> If I click on the link >> type=3D"submit" value=3D"Supprimer" style=3D"width: 100px; " />
>> I have the SELECT problem
>>
>> I will be crazy
>>
>> Cordialement,
>>
>> David DURIEUX
>> Tel : 04.74.04.81.34
>> Port : 06.34.99.45.18
>> Mail : d.durieux@siprossii.com
>> Site Web : http://www.siprossii.com/
>>
>> SIPROSSII
>> 847 route de Frans (Cr=E9acit=E9)
>> 69400 Villefranche sur Sa=F4ne
>>
>>
>>
>> Le Wed, 3 Sep 2008 21:08:25 +0200
>> David DURIEUX a =E9crit:
>>
>>>Bonjour,
>>>
>>>It was difficult, I have many files in includes, I will try to
>>>execute this code before in the php execution to see what code give
>>>problem.
>>>
>>>I try this now and I tell you the results of investigations
>>>
>>>
>>>Cordialement,
>>>
>>>David DURIEUX
>>>Tel : 04.74.04.81.34
>>>Port : 06.34.99.45.18
>>>Mail : d.durieux@siprossii.com
>>>Site Web : http://www.siprossii.com/
>>>
>>>SIPROSSII
>>>847 route de Frans (Cr=E9acit=E9)
>>>69400 Villefranche sur Sa=F4ne
>>>
>>>
>>>
>>>Le Wed, 3 Sep 2008 21:01:14 +0200
>>>"Evert Lammerts" a =E9crit:
>>>
>>>>This is weird. Can you send over the complete file?
>>>>
>>>>On Wed, Sep 3, 2008 at 8:56 PM, David DURIEUX
>>>> wrote:
>>>>> Bonjour,
>>>>>
>>>>> Yes DELETE is executed and I have on my page :
>>>>> string(3) "140"
>>>>> int(0)
>>>>>
>>>>> Cordialement,
>>>>>
>>>>> David DURIEUX
>>>>> Tel : 04.74.04.81.34
>>>>> Port : 06.34.99.45.18
>>>>> Mail : d.durieux@siprossii.com
>>>>> Site Web : http://www.siprossii.com/
>>>>>
>>>>> SIPROSSII
>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>
>>>>>
>>>>>
>>>>> Le Wed, 3 Sep 2008 20:51:49 +0200
>>>>> "Evert Lammerts" a =E9crit:
>>>>>
>>>>>>But the DELETE is executed? If it is, and it's in the condition,
>>>>>>like in the above code:
>>>>>>
>>>>>>if ($row =3D mysql_fetch_assoc($query)) {
>>>>>> .... DELETE ...
>>>>>>}
>>>>>>
>>>>>>something apparently is fetched....
>>>>>>
>>>>>>On Wed, Sep 3, 2008 at 8:49 PM, David DURIEUX
>>>>>> wrote:
>>>>>>> Bonjour,
>>>>>>>
>>>>>>> Yes I'm using this query.... and no row select
>>>>>>>
>>>>>>> Cordialement,
>>>>>>>
>>>>>>> David DURIEUX
>>>>>>> Tel : 04.74.04.81.34
>>>>>>> Port : 06.34.99.45.18
>>>>>>> Mail : d.durieux@siprossii.com
>>>>>>> Site Web : http://www.siprossii.com/
>>>>>>>
>>>>>>> SIPROSSII
>>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> Le Wed, 3 Sep 2008 20:43:25 +0200
>>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>>
>>>>>>>>Are you still using the code we talked about?
>>>>>>>>
>>>>>>>>if ($row =3D mysql_fetch_assoc($query)) {
>>>>>>>> var_dump ($row);
>>>>>>>> mysql_query("DELETE FROM table WHERE
>>>>>>>> id=3D{$row['id']}") or
>>>>>>>>die("delete error: " . mysql_error());
>>>>>>>>}
>>>>>>>>
>>>>>>>>if so, apparently it does fetch a row. Otherwise, can you send
>>>>>>>>the code you're using?
>>>>>>>>
>>>>>>>>On Wed, Sep 3, 2008 at 8:35 PM, David DURIEUX
>>>>>>>> wrote:
>>>>>>>>> Bonjour,
>>>>>>>>>
>>>>>>>>> I have always the problem, select =3D 0 rows and it delete it
>>>>>>>>> like if delete is before the select :/
>>>>>>>>>
>>>>>>>>> Cordialement,
>>>>>>>>>
>>>>>>>>> David DURIEUX
>>>>>>>>> Tel : 04.74.04.81.34
>>>>>>>>> Port : 06.34.99.45.18
>>>>>>>>> Mail : d.durieux@siprossii.com
>>>>>>>>> Site Web : http://www.siprossii.com/
>>>>>>>>>
>>>>>>>>> SIPROSSII
>>>>>>>>> 847 route de Frans (Cr=E9acit=E9)
>>>>>>>>> 69400 Villefranche sur Sa=F4ne
>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> Le Wed, 3 Sep 2008 20:05:22 +0200
>>>>>>>>> "Evert Lammerts" a =E9crit:
>>>>>>>>>
>>>>>>>>>>On Wed, Sep 3, 2008 at 7:58 PM, Evert Lammerts
>>>>>>>>>> wrote:
>>>>>>>>>>> On Wed, Sep 3, 2008 at 7:41 PM, Dee Ayy
>>>>>>>>>>> wrote:
>>>>>>>>>>>> When using mysql_query, the SQL string to be executed
>>>>>>>>>>>> should not end in a semicolon.
>>>>>>>>>>>
>>>>>>>>>>> Ending a query with a semicolon should not be a problem -
>>>>>>>>>>> the string is parsed by the mysql server, which handles it
>>>>>>>>>>> fine.
>>>>>>>>>>
>>>>>>>>>>The manual does mention it, I'm a little too quick with my
>>>>>>>>>>replies. I personally never had a problem with it though.
>>>>>>>>>>Plus, it seemed to work some mails ago.
>>>>>>>>>>
>>>>>>>>>>David, did I understand well that your problem is solved?
>>>>>>>>>>
>>>>>>>>>
>>>>>>>>>
>>>>>>>>> --
>>>>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>>>>
>>>>>>>>>
>>>>>>>
>>>>>>>
>>>>>>> --
>>>>>>> PHP Database Mailing List (http://www.php.net/)
>>>>>>> To unsubscribe, visit: http://www.php.net/unsub.php
>>>>>>>
>>>>>>>
>>>>>
>>>>>
>>>
>>>
>>
>>
>> --
>> PHP Database Mailing List (http://www.php.net/)
>> To unsubscribe, visit: http://www.php.net/unsub.php
>>
>>


--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php